{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["PREVISÃO DA RECEITA","PREVISÃO DE DESPESA","CONTRATAÇÃO DE PESSOAL","RESUMO","ACOMPANHAMENTO 1","ACOMPANHAMENTO 2","AUXILIAR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":126,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PREVISÃO DA RECEITA","index":0,"n_rows":29,"n_cols":31,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,2,1,14],[7,4,7,17],[16,7,16,13],[16,14,16,17],[0,0,0,17],[11,0,11,17],[10,9,10,17],[10,3,10,4],[7,0,7,3],[6,0,6,3],[6,4,6,17],[8,4,8,17],[9,11,9,17],[12,1,13,16],[9,0,9,3],[9,4,9,8],[24,2,25,5],[24,6,25,14],[17,0,17,6],[15,7,15,13],[15,14,15,17],[15,0,15,6],[8,0,8,3],[13,27,13,29],[9,9,9,10],[17,7,17,17],[14,0,14,6],[16,27,16,29],[14,27,14,29],[14,7,14,13],[14,14,14,17],[16,0,16,6],[15,27,15,29]]}
[]
[]
[]
[]
[]
[]
["PROGRAMA/PROJETO:"]
["COORDENADOR (A):"]
["PERÍODO DE EXECUÇÃO:"]
["CÓDIGO DO PROJETO:",null,null,null,null,null,null,null,null,"CONTA CORRENTE:"]
[]
["PREVISÃO DE RECEITA"]
[]
[]
["NOME DO ÓRGÃO FINANCIADOR",null,null,null,null,null,null,"ORIGEM DOS RECURSOS",null,null,null,null,null,null,"VALOR",null,null,null,null,null,2]
["NEOENERGIA"]
[]
["TOTAL DA PREVISÃO DE RECEITA",null,null,null,null,null,null,{"$f":"SUM(O16:R17)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orgãos do Governo Federal, Estadual, Municipal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Órgãos não Governamentais"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Órgãos/ Entidades Economia Mista e Privada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Org. Estrangeiras e Internacionais"]
[null,null,"ATUALIZADO EM ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Patrocínios"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concursos e Seleções"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cursos de Pós-graduação"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doações e subvenções"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outras Fontes de Recursos"]

{"sheet":"PREVISÃO DE DESPESA","index":1,"n_rows":185,"n_cols":48,"rows_kept":185,"cut":false,"hidden":false,"merged":[[57,0,57,7],[65,1,65,4],[64,1,64,4],[64,6,64,7],[67,1,67,4],[67,6,67,7],[68,1,68,4],[68,6,68,7],[60,0,60,4],[65,6,65,7],[61,1,61,4],[63,1,63,4],[63,6,63,7],[62,1,62,4],[62,6,62,7],[61,6,61,7],[73,3,73,5],[74,1,74,2],[103,1,103,7],[74,3,74,5],[72,0,72,4],[82,1,82,3],[82,4,82,5],[71,0,71,8],[90,0,90,7],[76,0,76,7],[78,0,78,4],[79,0,79,4],[80,4,80,5],[75,1,75,2],[75,3,75,5],[80,1,80,3],[73,1,73,2],[60,14,60,23],[66,6,66,7],[66,1,66,4],[131,0,131,7],[120,0,120,4],[120,6,120,7],[121,6,121,7],[126,0,126,1],[125,0,125,4],[121,0,121,4],[127,2,127,3],[128,2,128,3],[126,2,126,3],[129,0,129,7],[126,4,126,5],[127,4,127,5],[128,6,128,7],[128,4,128,5],[127,6,127,7],[83,0,83,7],[127,0,127,1],[126,6,126,7],[122,0,122,4],[123,0,123,7],[122,6,122,7],[128,0,128,1],[1,0,1,8],[3,0,3,8],[30,5,30,6],[10,0,10,7],[115,0,115,7],[119,0,119,4],[86,0,86,4],[116,0,116,7],[117,0,117,7],[102,1,102,7],[95,1,95,2],[101,0,101,4],[100,0,100,9],[93,0,93,4],[96,3,96,5],[111,1,111,2],[111,3,111,5],[97,0,97,7],[109,1,109,2],[105,0,105,7],[89,1,89,7],[94,1,94,2],[2,54,2,56],[3,54,3,56],[29,5,29,6],[16,0,16,7],[5,0,5,9],[24,0,24,7],[6,0,6,4],[8,5,8,6],[8,3,8,4],[12,0,12,4],[7,3,7,4],[13,3,13,6],[18,0,18,4],[27,0,27,4],[28,0,28,8],[7,5,7,6],[19,3,19,7],[22,0,22,7],[9,3,9,4],[9,5,9,6],[6,14,6,26],[45,11,45,12],[41,6,41,7],[56,1,56,2],[40,6,40,7],[56,3,56,5],[42,0,42,7],[50,0,50,7],[54,3,54,5],[114,0,114,4],[109,3,109,5],[110,3,110,5],[112,0,112,7],[108,0,108,4],[88,1,88,7],[94,3,94,5],[110,1,110,2],[81,4,81,5],[81,1,81,3],[87,1,87,7],[104,1,104,7],[99,0,99,8],[95,3,95,5],[96,1,96,2],[69,0,69,7],[31,5,31,6],[32,5,32,6],[45,1,45,7],[39,6,39,7],[38,6,38,7],[52,0,52,8],[53,0,53,4],[54,1,54,2],[55,1,55,2],[55,3,55,5],[33,0,33,7],[36,0,36,4],[44,0,44,4],[37,6,37,7],[60,43,60,47],[61,43,61,47],[62,43,62,45],[61,36,61,40],[62,36,62,38],[6,27,6,34],[7,29,7,30],[7,27,7,28],[7,31,7,32],[7,33,7,34],[60,36,60,40]]}
[]
["PREVISÃO DA DESPESA "]
[]
["ELEMENTOS DE DESPESAS"]
[]
[]
["319011   DESPESAS COM PESSOAL",null,null,null,null,null,null,null,null,null,null,null,2,null,"Tabela para Cálculo dos Descontos"]
["Item","CPF","Função","Nome",null,"REMUNERAÇÃO BRUTA (R$)",null,"QUANT. MESES","TOTAL  DE SALÁRIO BRUTO (R$)",null,0,null,null,null,"Valor Líquido","Alíquota do INSS","INSS","Valor descontado do INSS","1ª Faixa (INSS)","2ª Faixa (INSS)","3ª Faixa (INSS)","4ª Faixa (INSS)","IR","2ª Faixa (IR)","3ª Faixa (IR)","4ª Faixa (IR)","5ª Faixa (IR)","1ª Faixa (INSS)",null,"2ª Faixa (INSS)",null,"3ª Faixa (INSS)",null,"4ª Faixa (INSS)"]
[{"$f":"K9","v":1},null,null,null,null,5000,null,36,{"$f":"F9*H9","v":180000},null,{"$f":"K8+1","v":1},null,null,null,{"$f":"IF(F9>0,F9-Q9-W9,0)","v":4103.3500000000004},{"$f":"IF($F9<=$AT$64,$AU$64,IF($F9<=$AT$65,$AU$65,IF($F9<=$AT$66,$AU$66,IF($F9<=$AT$67,$AU$67,$AU$67))))","v":0.14000000000000001},{"$f":"S9+T9+U9+V9","v":526.16999999999996},{"$f":"F9-Q9","v":4473.83},{"$f":"IF(AC9>0,ROUND(AC9,2),0)","v":97.65},{"$f":"IF(AE9>0,ROUNDDOWN(AE9,2),0)","v":114.23},{"$f":"IF(AG9>0,ROUNDDOWN(AG9,2),0)","v":154.27000000000001},{"$f":"IF(AI9>0,ROUNDDOWN(AI9,2),0)","v":160.02000000000001},{"$f":"SUM(X9:AA9)","v":370.48},{"$f":"ROUNDDOWN(IF($R9>$AM$65,($AM$65-$AM$64)*$AN$65,IF(AND($R9>=$AK$65,$R9<=$AM$65),($R9-$AK$65)*$AN$65,0)),2)","v":69.2},{"$f":"ROUNDDOWN(IF($R9>$AM$66,($AM$66-$AM$65)*$AN$66,IF(AND($R9>=$AK$66,$R9<=$AM$66),($R9-$AK$66)*$AN$66,0)),2)","v":138.66},{"$f":"ROUNDDOWN(IF($R9>$AM$67,($AM$67-$AM$66)*$AN$67,IF(AND($R9>=$AK$67,$R9<=$AM$67),($R9-$AK$67)*$AN$67,0)),2)","v":162.62},{"$f":"ROUNDDOWN(IF($R9>$AM$68,($R9-$AM$68)*$AN$68,0),2)","v":0},{"$f":"IF($F9>=$AT$64,$AT$64*$AU$64,$F9*$AU$64)","v":97.649999999999991},{"$f":"IF(AB9>0,AB9,0)","v":97.649999999999991},{"$f":"IF($F9>=$AT$65,(($AT$65-$AT$64)*$AU$65)+AB9,(($F9-$AT$64)*$AU$65)+AB9)","v":211.8861},{"$f":"IF(AD9>0,AD9-AC9,0)","v":114.23610000000001},{"$f":"IF($F9>=$AT$66,(($AT$66-$AT$65)*$AU$66)+AD9,(($F9-$AT$65)*$AU$66)+AD9)","v":366.16409999999996},{"$f":"IF(AF9>0,AF9-AC9-AE9,0)","v":154.27799999999996},{"$f":"IF($F9>=$AT$67,(($AT$67-$AT$66)*$AU$67)+AF9,(($F9-$AT$66)*$AU$67)+AF9)","v":526.1925},{"$f":"IF(AH9>0,AH9-AG9-AE9-AC9,0)","v":160.02840000000003}]
[{"$f":"K10","v":2},null,null,null,null,0,null,0,{"$f":"F10*H10","v":0},null,{"$f":"K9+1","v":2},null,null,null,{"$f":"IF(F10>0,F10-Q10-W10,0)","v":0},{"$f":"IF($F10<=$AT$64,$AU$64,IF($F10<=$AT$65,$AU$65,IF($F10<=$AT$66,$AU$66,IF($F10<=$AT$67,$AU$67,$AU$67))))","v":7.4999999999999997E-2},{"$f":"S10+T10+U10+V10","v":0},{"$f":"F10-Q10","v":0},{"$f":"IF(AC10>0,ROUND(AC10,2),0)","v":0},{"$f":"IF(AE10>0,ROUNDDOWN(AE10,2),0)","v":0},{"$f":"IF(AG10>0,ROUNDDOWN(AG10,2),0)","v":0},{"$f":"IF(AI10>0,ROUNDDOWN(AI10,2),0)","v":0},{"$f":"SUM(X10:AA10)","v":0},{"$f":"ROUNDDOWN(IF($R10>$AM$65,($AM$65-$AM$64)*$AN$65,IF(AND($R10>=$AK$65,$R10<=$AM$65),($R10-$AK$65)*$AN$65,0)),2)","v":0},{"$f":"ROUNDDOWN(IF($R10>$AM$66,($AM$66-$AM$65)*$AN$66,IF(AND($R10>=$AK$66,$R10<=$AM$66),($R10-$AK$66)*$AN$66,0)),2)","v":0},{"$f":"ROUNDDOWN(IF($R10>$AM$67,($AM$67-$AM$66)*$AN$67,IF(AND($R10>=$AK$67,$R10<=$AM$67),($R10-$AK$67)*$AN$67,0)),2)","v":0},{"$f":"ROUNDDOWN(IF($R10>$AM$68,($R10-$AM$68)*$AN$68,0),2)","v":0},{"$f":"IF($F10>=$AT$64,$AT$64*$AU$64,$F10*$AU$64)","v":0},{"$f":"IF(AB10>0,AB10,0)","v":0},{"$f":"IF($F10>=$AT$65,(($AT$65-$AT$64)*$AU$65)+AB10,(($F10-$AT$64)*$AU$65)+AB10)","v":-117.17999999999999},{"$f":"IF(AD10>0,AD10-AC10,0)","v":0},{"$f":"IF($F10>=$AT$66,(($AT$66-$AT$65)*$AU$66)+AD10,(($F10-$AT$65)*$AU$66)+AD10)","v":-425.73480000000001},{"$f":"IF(AF10>0,AF10-AC10-AE10,0)","v":0},{"$f":"IF($F10>=$AT$67,(($AT$67-$AT$66)*$AU$67)+AF10,(($F10-$AT$66)*$AU$67)+AF10)","v":-965.70640000000003},{"$f":"IF(AH10>0,AH10-AG10-AE10-AC10,0)","v":0}]
["SUBTOTAL",null,null,null,null,null,null,null,{"$f":"SUM(I9:I10)","v":180000}]
[]
["319013   ENCARGOS SOCIAIS"]
["Item","CPF","FUNÇÃO","NOME",null,null,null,"QUANT. MESES","VALOR  (R$)"]
[{"$f":"+A9","v":1},{"$f":"B9","v":0},0,0,null,null,null,{"$f":"+H9","v":36},{"$f":"+'CONTRATAÇÃO DE PESSOAL'!J19*H9","v":63540}]
[{"$f":"+A10","v":2},0,0,0,null,null,null,{"$f":"+H10","v":0},{"$f":"+'CONTRATAÇÃO DE PESSOAL'!J20*H10","v":0}]
["SUBTOTAL",null,null,null,null,null,null,null,{"$f":"SUM(I15:I16)","v":63540}]
[]
["999999   OBRIGAÇÕES PATRONAIS SOBRE FÉRIAS, 13º  SALÁRIO E RESCISÃO CONTRATUAL"]
["Item","CPF","FUNÇÃO","NOME",null,null,null,null,"VALOR  (R$)"]
[{"$f":"+A9","v":1},{"$f":"B9","v":0},0,0,null,null,null,null,{"$f":"'CONTRATAÇÃO DE PESSOAL'!AH19","v":52778}]
[{"$f":"+A10","v":2},0,0,0,null,null,null,null,{"$f":"'CONTRATAÇÃO DE PESSOAL'!AH20","v":0}]
["SUBTOTAL",null,null,null,null,null,null,null,{"$f":"SUM(I21:I22)","v":52778}]
[]
["TOTAL (pessoal + encargos sociais + obrigações patronais)",null,null,null,null,null,null,null,{"$f":"I17+I11+I23","v":296318}]
[]
[]
["339020   BOLSA DE ENSINO, PESQUISA E EXTENSÃO",null,null,null,null,null,null,null,null,null,null,null,3]
[]
["Item","CPF","BENEFICIÁRIO","MODALIDADE","CATEGORIA/ TITULAÇÃO","VALOR DA BOLSA  (R$)",null,"QUANT. MESES","VALOR     BOLSA (R$)",null,0]
[{"$f":"K31","v":1},null,null,null,null,null,null,null,{"$f":"+F31*H31","v":0},null,{"$f":"K30+1","v":1}]
[{"$f":"K32","v":2},null,null,null,null,null,null,null,{"$f":"+F32*H32","v":0},null,{"$f":"K31+1","v":2}]
[{"$f":"K33","v":3},null,null,null,null,null,null,null,{"$f":"+F33*H33","v":0},null,{"$f":"K32+1","v":3}]
["TOTAL BOLSA DE ENSINO, PESQUISA E EXTENSÃO",null,null,null,null,null,null,null,{"$f":"SUM(I31:I33)","v":0}]
[]
[]
["339018.01   ESTUDANTE - BOLSA ESTÁGIO",null,null,null,null,null,null,null,null,null,null,null,4]
["Nº","CPF","ESTUDANTE","INSTITUIÇÃO DE ENSINO","CURSO / Nº MATRICULA","QUANT. MESES","VALOR BOLSA (R$)",null," TOTAL (R$)",null,0]
[{"$f":"K39","v":1},null,null,null,null,null,null,null,{"$f":"F39*G39","v":0},null,{"$f":"K38+1","v":1}]
[{"$f":"K40","v":2},null,null,null,null,null,null,null,{"$f":"F40*G40","v":0},null,{"$f":"K39+1","v":2}]
[{"$f":"K41","v":3},null,null,null,null,null,null,null,{"$f":"F41*G41","v":0},null,{"$f":"K40+1","v":3}]
[{"$f":"K42","v":4},null,null,null,null,null,null,null,{"$f":"F42*G42","v":0},null,{"$f":"K41+1","v":4}]
["TOTAL BOLSA ESTÁGIO",null,null,null,null,null,null,null,{"$f":"SUM(I39:I42)","v":0}]
[]
["339039 SERVIÇO DE TERCEIRO PESSOA JURÍDICA - SEGURO ESTÁGIO"]
["Nº","ESTUDANTE",null,null,null,null,null,null,"VALOR SEGURO (R$)"]
[{"$f":"A39","v":1},{"$f":"C39","v":0},null,null,null,null,null,null,{"$f":"F39*1.38","v":0}]
[{"$f":"A40","v":2},{"$f":"C40","v":0},null,null,null,null,null,null,{"$f":"F40*1.38","v":0}]
[{"$f":"A41","v":3},{"$f":"C41","v":0},null,null,null,null,null,null,0]
[{"$f":"A42","v":4},{"$f":"C42","v":0},null,null,null,null,null,null,0]
["TOTAL DO SEGURO",null,null,null,null,null,null,null,{"$f":"SUM(I47:I50)","v":0}]
[]
[]
["339018.02   AUXILIO FINANCEIRO A ESTUDANTES",null,null,null,null,null,null,null,null,null,null,null,2]
["Item","LOCALIDADE",null,"FINALIDADE",null,null,"QUANT.","VALOR UNIT. (R$)","TOTAL (R$)","Vr Total da Diária"]
[{"$f":"K56","v":1},null,null,null,null,null,null,null,{"$f":"G56*H56","v":0},null,{"$f":"K55+1","v":1}]
[{"$f":"K57","v":2},null,null,null,null,null,null,null,{"$f":"G57*H57","v":0},null,{"$f":"K56+1","v":2}]
["TOTAL DE AUXILIO FINANCEIRO A ESTUDANTES",null,null,null,null,null,null,null,{"$f":"SUM(I56:I57)","v":0}]
[]
[]
["339036   CONTRATAÇÃO SERVIÇOS DE TERCEIROS PESSOA FÍSICA",null,null,null,null,null,null,null,null,null,null,null,7,null,"Tabela para Cálculo dos Descontos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabela Progressiva Mensal de IRRF",null,null,null,null,null,null,"Tabela de Contribuição Mensal do INSS"]
["Item","DESCRIÇÃO DETALHADA DO SERVIÇO A SER CONTRATADO PARA O PROGRAMA / PROJETO",null,null,null,"QUANT.","VALOR DA PARCELA (R$)",null,"VALOR BRUTO (R$)",null,0,null,null,null,"Valor Líquido","Alíquota do ISS","ISS","INSS","Valor descontado do INSS","IR","2ª Faixa (IR)","3ª Faixa (IR)","4ª Faixa (IR)","5ª Faixa (IR)",null,null,null,null,null,null,null,null,null,null,null,null,"Ano-calendário 2023",null,null,null,null,null,null,"1º de janeiro de 2023"]
[{"$f":"K63","v":1},null,null,null,null,0,0,null,{"$f":"F63*G63","v":0},null,{"$f":"K62+1","v":1},null,null,null,{"$f":"G63-Q63-R63-T63","v":0},0.05,{"$f":"ROUND(G63*P63,2)","v":0},{"$f":"ROUND(IF(G63>$AT$68,$AT$68*11%,G63*11%),2)","v":0},{"$f":"G63-R63","v":0},{"$f":"SUM(U63:X63)","v":0},{"$f":"ROUNDDOWN(IF($S63>$AM$65,($AM$65-$AM$64)*$AN$65,IF(AND($S63>=$AK$65,$S63<=$AM$65),($S63-$AK$65)*$AN$65,0)),2)","v":0},{"$f":"ROUNDDOWN(IF($S63>$AM$66,($AM$66-$AM$65)*$AN$66,IF(AND($S63>=$AK$66,$S63<=$AM$66),($S63-$AK$66)*$AN$66,0)),2)","v":0},{"$f":"ROUNDDOWN(IF($S63>$AM$67,($AM$67-$AM$66)*$AN$67,IF(AND($S63>=$AK$67,$S63<=$AM$67),($S63-$AK$67)*$AN$67,0)),2)","v":0},{"$f":"ROUNDDOWN(IF($S63>$AM$68,($S63-$AM$68)*$AN$68,0),2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Base de Cálculo Mensal em R$",null,null,"Alíquota","Dedução",null,null,"Base de Cálculo Mensal em R$",null,null,"Alíquota","Dedução"]
[2,null,null,null,null,null,null,null,{"$f":"F64*G64","v":0},null,{"$f":"K63+1","v":2},null,null,null,0,0.05,{"$f":"ROUND(G64*P64,2)","v":0},0,0,{"$f":"SUM(U64:X64)","v":0},0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1,0.01,"até",1903.98,0,null,null,null,0.01,"até",1302,7.4999999999999997E-2]
[3,null,null,null,null,null,null,null,0,null,3,null,null,null,0,0.05,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,2,1903.99,"até",2826.65,7.4999999999999997E-2,142.80000000000001,null,null,{"$f":"AT64+0.01","v":1302.01},"até",2571.29,0.09,{"$f":"(AU65-AU64)*AT64","v":19.529999999999998}]
[4,null,null,null,null,null,null,null,0,null,4,null,null,null,0,0.05,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,3,2826.66,"até",3751.05,0.15,354.8,null,null,{"$f":"AT65+0.01","v":2571.3000000000002},"até",3856.94,0.12,{"$f":"(AU66-AU65)*AT65+AV65","v":96.668700000000001}]
[5,null,null,null,null,null,null,null,0,null,5,null,null,null,0,0.05,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,4,3751.05,"até",4664.68,0.22500000000000001,636.13,null,null,3856.9500000000003,"até",7507.49,0.14000000000000001,148.71]
[6,null,null,null,null,null,null,null,0,null,6,null,null,null,0,0.05,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,5,null,"acima de",4664.6899999999996,0.27500000000000002,869.36,null,null,null,"acima de",7507.49,0.14000000000000001,{"$f":"AT68*AU68-AV67","v":902.33860000000004}]
[7,null,null,null,null,null,null,null,0,null,7,null,null,null,0,0.05,0,0,0,0,0,0,0,0]
["TOTAL DO SERVIÇO DE TERCEIROS PESSOA FISICA",null,null,null,null,null,null,null,{"$f":"SUM(I63:I69)","v":0}]
[]
[]
["339014   DIÁRIAS",null,null,null,null,null,null,null,null,null,null,null,2]
["Item","LOCALIDADE",null,"FINALIDADE",null,null,"QUANT.","VALOR UNIT. (R$)","TOTAL (R$)","Vr Total da Diária"]
[{"$f":"K75","v":1},null,null,null,null,null,null,null,{"$f":"G75*H75","v":0},null,{"$f":"K74+1","v":1}]
[{"$f":"K76","v":2},null,null,null,null,null,null,null,{"$f":"G76*H76","v":0},null,{"$f":"K75+1","v":2}]
["TOTAL DE DIÁRIAS",null,null,null,null,null,null,null,{"$f":"SUM(I75:I76)","v":0}]
[]
[]
["339033   PASSAGEM E DESPESA COM LOCOMOÇÃO",null,null,null,null,null,null,null,null,null,null,null,2]
["Item","DESTINO",null,null,"MEIO DE TRANSPORTE",null,"QUANT.","VALOR UNIT. (R$)","TOTAL (R$)","Vr Total da Diária",0]
[{"$f":"K82","v":1},null,null,null,null,null,null,null,{"$f":"G82*H82","v":0},null,{"$f":"K81+1","v":1}]
[{"$f":"K83","v":2},null,null,null,null,null,null,null,{"$f":"G83*H83","v":0},null,{"$f":"K82+1","v":2}]
["TOTAL ",null,null,null,null,null,null,null,{"$f":"SUM(I82:I83)","v":0}]
[]
[]
["339030   MATERIAL DE CONSUMO",null,null,null,null,null,null,null,null,null,null,null,2]
["Item","CATEGORIA",null,null,null,null,null,null,"TOTAL (R$)","Vr Total da Diária",0]
[{"$f":"K89","v":1},null,null,null,null,null,null,null,null,null,{"$f":"K88+1","v":1}]
[{"$f":"K90","v":2},null,null,null,null,null,null,null,null,null,{"$f":"K89+1","v":2}]
["TOTAL ",null,null,null,null,null,null,null,{"$f":"SUM(I89:I90)","v":0}]
[]
[]
["339039   SERVIÇO TERCEIRO PESSOA JURÍDICA",null,null,null,null,null,null,null,null,null,null,null,2]
["Item","CATEGORIA",null,"DESCRIÇÃO",null,null,"QUANT.","VALOR UNIT. (R$)","TOTAL (R$)",null,0]
[{"$f":"K96","v":1},null,null,null,null,null,null,null,{"$f":"G96*H96","v":0},null,{"$f":"K95+1","v":1}]
[{"$f":"K97","v":2},null,null,null,null,null,null,null,{"$f":"G97*H97","v":0},null,{"$f":"K96+1","v":2}]
["TOTAL ",null,null,null,null,null,null,null,{"$f":"SUM(I96:I97)","v":0}]
[]
["INVESTIMENTO"]
[]
["449051  OBRAS E INSTALAÇÕES",null,null,null,null,null,null,null,null,null,null,null,2]
["Item","DESCRIÇÃO",null,null,null,null,null,null,"TOTAL (R$)",null,0]
[{"$f":"K104","v":1},null,null,null,null,null,null,null,null,null,{"$f":"K103+1","v":1}]
[{"$f":"K105","v":2},null,null,null,null,null,null,null,null,null,{"$f":"K104+1","v":2}]
["TOTAL ",null,null,null,null,null,null,null,{"$f":"SUM(I104:I105)","v":0}]
[]
[]
["449052   EQUIPAMENTO E MATERIAL PERMANENTE",null,null,null,null,null,null,null,null,null,null,null,2]
["Item","CATEGORIA",null,"DESCRIÇÃO",null,null,"QUANT.","VALOR UNIT. (R$)","TOTAL (R$)","Vr Total da Diária",0]
[{"$f":"K111","v":1},null,null,null,null,null,null,null,{"$f":"G111*H111","v":0},null,{"$f":"K110+1","v":1}]
[{"$f":"K112","v":2},null,null,null,null,null,null,null,{"$f":"G112*H112","v":0},null,{"$f":"K111+1","v":2}]
["TOTAL ",null,null,null,null,null,null,null,{"$f":"SUM(I111:I112)","v":0}]
[]
["339047 OBRIGAÇÕES TRIBUTÁRIAS CONTRIBUTIVAS"]
["ENCARGOS SOCIAIS",null,null,null,null,null,null,null,"VALOR (R$)"]
["INSS Empresa (20% s/ STPF) ",null,null,null,null,null,null,null,{"$f":"+I70*20%","v":0}]
["TOTAL",null,null,null,null,null,null,null,{"$f":"I117","v":0}]
[]
["339039 SERVIÇOS DE TERCEIRO PESSOA JURÍDICA"]
["ESPECIFICAÇÃO",null,null,null,null,"PERCENT.","BASE DE CÁLCULO",null,"VALOR (R$)"]
["Tarifas bancárias",null,null,null,null,1.4999999999999999E-2,{"$f":"I25+I34+I43+I70+I77+I84+I91+I98+I106+I113+I118+I130+I123+I51+I58","v":325949.8},null,{"$f":"F122*G122","v":4889.2469999999994}]
["Gestão administrativo-financeira",null,null,null,null,0.1,{"$f":"I25+I34+I43+I70+I77+I84+I91+I98+I106+I113+I118+I130+I51+I58","v":296318},null,{"$f":"F123*G123","v":29631.800000000003}]
["TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(I122:I123)","v":34521.047000000006}]
[]
["339041 CONTRIBUIÇÕES"]
["DESCRIÇÃO",null,"ÓRGÃO",null,"PERCENTUAL",null,"BASE DE CÁLCULO",null,"VALOR (R$)"]
["Gestão Acadêmica - UFAL",null,null,null,null,null,{"$f":"+I25+I34+I43+I70+I77+I84+I91+I98+I106+I113+I118+I51+I58","v":296318},null,{"$f":"E128*G128","v":0}]
["Gestão Acadêmica - U.A.",null,null,null,null,null,{"$f":"+I25+I34+I43+I70+I77+I84+I91+I98+I106+I113+I118+I51+I58","v":296318},null,{"$f":"+G129*E129","v":0}]
["TOTAL",null,null,null,null,null,null,null,{"$f":"SUM(I128:I129)","v":0}]
[]
["TOTAL GERAL",null,null,null,null,null,null,null,{"$f":"I25+totalRubrica02+totalRubrica03+I51+rubricaFim_13+totalRubrica04+totalRubrica05+totalRubrica06+totalRubrica07+totalRubrica08+totalRubrica09+totalRubrica10+totalRubrica12+I124+I130","v":330839.04700000002}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meio de Transporte","Material de Consumo","Material Permanente","Serviços de Terceiros Pessoa Jurídica","Categoria / Titulação: pesquisa","Servidor: Pesquisa","Servidor: Outros"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Áereo","Alimentos para Animais","Acessório para Automóveis","Aquisição de Softwares de Aplicação","Pesquisa","Servidor Público","Servidor UFAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rodoviário","Animais para Pesquisa e Abate","Aparelhos de Medição e Orientação","Armazenagem","Ensino","Servidor UFAL","Servidor IFAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Automóvel","Aquisição de Software de Base","Aparelhos e Equipamentos de Comunicação","Assinaturas de Periódicos e Anuidades","Extensão","Servidor IFAL","Outros"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outros","Combustível e lubrificantes","Aparelhos e Equipamentos p/ Esportes e Diversões","Comissão e Corretagens","Inovação Tecnológica","Militar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferramentas","Aparelhos e Utensílios Domésticos","Condomínios",null,"Discente"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gás Engarrafado","Aparelhos, Equipamentos, Utensílios médico e Hospitalares","Confecção de Material de Acondicionamento e Embalagem",null,"Outros"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gêneros de Alimentação","Aparelhos, Equipamentos, Utensílios Laboratoriais e odontológicos","Confecção de Uniformes e outros"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. e Medicamentos para Uso Veterinário","Coleções e Materiais Bibliográficos","Despesas com Teleprocessamento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. Bibliográfico Não Imobilizado","Discotecas e Filmotecas","Direitos Autorais"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. Biológico e odontológico","Embarcações","Exposição Congressos e Conferências"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Caça e Pesca","Equipamento de Processamento de Dados","Fornecimento de Alimentação"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Cama Mesa e Banho","Equipamentos de Áudio Vídeo e Foto","Fretes e Transportes de Ecomendas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Copa e Cozinha","Equipamentos de Mergulho e Salvamento","Hospedagem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Coudelaria ou de Uso Zootécnico","Equipamentos e Sistemas de Proteção e Vigilãncia Ambiental","Limpeza e Conservação"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Expediente","Equipamentos e Utensílios Hidráulicos e Elétricos","Locação Bens móveis e outras naturezas e intangíveis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Limpeza e Produção de Higienização","Equipamentos, peças e acessórios marítmos","Locação de Imóveis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Manobra e Patrulhamento","Instrumentos Musicias e Artísticos","Locação de Máquinas e Equipamentos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Processamento de Dados","Máquinas e Equipamentos Agrícolas e Rodoviários","Locação de Software"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Proteção e Segurança","Máquinas e Equipamentos de Natureza Industriais","Manutenção Conservação de Equip.Processamento de Dados"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. de Sinalização Visual e Afins","Máquinas e Equipamentos Energéticos","Manutenção de  Software"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. Educativo e Esportivo","Máquinas e Equipamentos Gráficos","Manutenção e Conservação de Bens Imóveis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Material Elétrico e Eletrônico","Máquinas, Ferramentas e Utensílios de Oficina","Manutenção e Conservação de Bens Móveis de outras Naturezas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. Farmacológico e Hospitalar","Máquinas, Instalações e Utensílios de Escritório","Manutenção e Conservação de Estradas e Vias"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. Laboratorial e Químico","Máquinas, Utensílios e Equipamentos Diversos","Manutenção e Conservação de Maq. e Equipamentos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. para Audio. Video e Foto","Mobiliários em Geral","Manutenção e Conservação de Veículos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. para Comunicações","Obras de Arte e Peças de Museus","Produções Jornalísticas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. para Manutenção de Bens Imóveis","Peças não Incorporáveis a Imóveis","Seguros em Geral"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. para Manutenção de Bens Móveis","Semoventes e Equipamentos de Montaria","Serviço Médico-Hospitalar Odontológico e Laboratoriais"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. para Manutenção de Veículos","Veículos Diversos","Serviços Bancários"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. para Utilização em Gráfica","Outros Materiais Permanentes","Serviços de Água e Esgoto"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mat. Técnico p/ Seleção e Treinamento",null,"Serviços de Análises e Pesquisas Científicas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sementes, Mudas de Plantas e Insumos",null,"Serviços de áudio, vídeo e foto "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uniformes, Tecidos e Aviamentos",null,"Serviços de Comunicação em Geral"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outros Materias de Consumo",null,"Serviços de Cópias e Reprodução de Documentos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços de Energia Elétrica"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços de Gás"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços de Perícias Médicas por Benefícios"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços de Processamento de Dados"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços de publicidade e propaganda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços de Seleção e Treinamento"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços de Telecomunicação"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços Gráficos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços Judiciários"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Serviços Técnicos e Profissioniais"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transporte de Servidores"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vale Transporte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outros Serviços de Terceiros Pessoa Jurídica"]

{"sheet":"CONTRATAÇÃO DE PESSOAL","index":2,"n_rows":316,"n_cols":36,"rows_kept":316,"cut":false,"hidden":false,"merged":[[8,11,8,16],[16,6,16,9],[9,0,9,1],[16,1,16,5],[14,10,15,22],[16,10,16,18],[10,14,10,16],[16,34,17,34],[16,29,16,33],[11,38,11,40],[12,38,12,40],[16,35,17,35]]}
[]
[]
[]
[]
[]
[]
[]
["DETALHAMENTO DOS ENCARGOS SOCIAIS E DO FUNDO DE COBERTURA DO PASSIVO TRABALHISTA - FCPT"]
[null,null,null,null,null,null,null,null,null,null,null,"VALE TRANSPORTE SIM OU NÃO? SE SIM, INFORMAR VALOR DIÁRIO"]
["AVISO PRÉVIO INDENIZADO?",null,"NÃO",{"$f":"+IF(A10=0,\"    PREENCHA O CAMPO AO LADO\",\"\")","v":""},null,null,null,null,null,null,null,null,"SIM","SIM","Valor Médio Vale transporte"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NÃO",null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"FCPT"]
[]
["PROFISSIONAIS","REMUNERAÇÃO PREVISTOS NO ELEMENTO DE DESESA 319011",null,null,null,null,"ENCARGOS SOCIAIS SOBRE SALÁRIO PREVISTOS NO ELEMENTO DE DESPESA 319013",null,null,null,"OBRIGAÇÕES PATRONAIS SOBRE FÉRIAS, 13º  SALÁRIO",null,null,null,null,null,null,null,null,"RESCISÃO","CUSTOS TOTAIS","MESES DE EXECUÇÃO","CUSTO TOTAL EXECUÇÃO","AVISO PRÉVIO INDENIZADO","AVISO PRÉVIO TRABALHADO","ENCARGO SOBRE AVISO INDENIZADO","FCPT MENSAL","VALE    TRANSPORTE","EXAME ADMISSIONAL/DEMISSIONAL","TOTAL DAS RUBRICAS",null,null,null,null,"TOTAL GERAL","TOTAL 11 e 13"]
["FUNÇÃO","QUANT. FUNCION.","SALÁRIO","GRATIFICAÇÃO","ADICIONAIS","TOTAL SALÁRIOS","FGTS ","INSS","PIS","TOTAL","13º SAL. 1/12 AVOS","FÉRIAS + 1/3 - 1/12 AVOS","13º AVISO PRÉVIO INDENIZADO","FÉRIAS AVISO PRÉVIO INDENIZADO","TOTAL","FGTS ","INSS","PIS","TOTAL","MULTA 40%","MENSAL","QUANTIDADE   (meses)","VALOR TOTAL","VALOR TOTAL","VALOR TOTAL","VALOR TOTAL","VALOR","VALOR","(35,00x2)","31.90.11","31.90.13","33.90.36","33.90.39",999999]
[{"$f":"+IF('PREVISÃO DE DESPESA'!C9=0,\" \",'PREVISÃO DE DESPESA'!C9)","v":" "},1,{"$f":"+'PREVISÃO DE DESPESA'!F9","v":5000},null,null,{"$f":"+(C19+D19+E19)*B19","v":5000},{"$f":"(F19)*8%","v":400},{"$f":"C19*26.3%","v":1315},{"$f":"(F19)*1%","v":50},{"$f":"SUM(G19:I19)","v":1765},{"$f":"F19/12","v":416.66666666666669},{"$f":"F19*11.11/100","v":555.5},{"$f":"+IF($C$10=\"NÃO\",0,IF(AND(V19>=1,V19<60),F19/12*1,IF(AND(V19>=60,V19<=168),F19/12*2,IF(AND(V19>168,V19<=240),F19/12*3,F19/12*3))))","v":0},{"$f":"+IF($C$10=\"NÃO\",0,IF(AND(V19>=1,V19<60),F19/12*1,IF(AND(V19>=60,V19<=168),F19/12*2,IF(AND(V19>168,V19<=240),F19/12*3,F19/12))))","v":0},{"$f":"SUM(K19:N19)","v":972.16666666666674},{"$f":"(K19+M19+(K19/3)+Y19)*8%","v":164.44444444444446},{"$f":"(K19+(K19/3))*26.3%","v":146.11111111111111},{"$f":"(K19+M19+(K19/3))*1%","v":5.5555555555555554},{"$f":"SUM(P19:R19)","v":316.11111111111109},{"$f":"(((F19+K19+M19+(K19/3))*(8%)*40%))","v":177.7777777777778},{"$f":"+F19+J19+O19+T19+S19","v":8231.0555555555547},{"$f":"+'PREVISÃO DE DESPESA'!H9","v":36},{"$f":"+U19*V19","v":296318},{"$f":"+IF($C$10=\"NÃO\",0,'PREVISÃO DE DESPESA'!F9/30*IF(+'PREVISÃO DE DESPESA'!H9<12,30,IF(AND(+'PREVISÃO DE DESPESA'!H9>=12,+'PREVISÃO DE DESPESA'!H9<24),33,IF(AND(+'PREVISÃO DE DESPESA'!H9>=24,+'PREVISÃO DE DESPESA'!H9<36),36,IF(AND(+'PREVISÃO DE DESPESA'!H9>=36,+'PREVISÃO DE DESPESA'!H9<48),39,IF(AND(+'PREVISÃO DE DESPESA'!H9>=48,+'PREVISÃO DE DESPESA'!H9<60),42,IF(AND(+'PREVISÃO DE DESPESA'!H9>=60,+'PREVISÃO DE DESPESA'!H9<72),45,IF(AND(+'PREVISÃO DE DESPESA'!H9>=72,+'PREVISÃO DE DESPESA'!H9<84),48,IF(AND(+'PREVISÃO DE DESPESA'!H9>=84,+'PREVISÃO DE DESPESA'!H9<96),51,IF(AND(+'PREVISÃO DE DESPESA'!H9>=96,+'PREVISÃO DE DESPESA'!H9<108),54,IF(AND(+'PREVISÃO DE DESPESA'!H9>=108,+'PREVISÃO DE DESPESA'!H9<120),57,IF(AND(+'PREVISÃO DE DESPESA'!H9>=120,+'PREVISÃO DE DESPESA'!H9<132),60,IF(AND(+'PREVISÃO DE DESPESA'!H9>=132,+'PREVISÃO DE DESPESA'!H9<144),63,IF(AND(+'PREVISÃO DE DESPESA'!H9>=144,+'PREVISÃO DE DESPESA'!H9<156),66,IF(AND(+'PREVISÃO DE DESPESA'!H9>=156,+'PREVISÃO DE DESPESA'!H9<168),69,IF(AND(+'PREVISÃO DE DESPESA'!H9>=168,+'PREVISÃO DE DESPESA'!H9<180),72,IF(AND(+'PREVISÃO DE DESPESA'!H9>=180,+'PREVISÃO DE DESPESA'!H9<192),75,IF(AND(+'PREVISÃO DE DESPESA'!H9>=192,+'PREVISÃO DE DESPESA'!H9<204),78,IF(AND(+'PREVISÃO DE DESPESA'!H9>=204,+'PREVISÃO DE DESPESA'!H9<216),81,IF(AND(+'PREVISÃO DE DESPESA'!H9>=216,+'PREVISÃO DE DESPESA'!H9<228),84,IF(AND(+'PREVISÃO DE DESPESA'!H9>=228,+'PREVISÃO DE DESPESA'!H9<240),87,90)))))))))))))))))))))","v":0},{"$f":"IF($C$10=\"SIM\",0,'PREVISÃO DE DESPESA'!F9/30*IF('PREVISÃO DE DESPESA'!H9<12,30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=12,'PREVISÃO DE DESPESA'!H9<24),33-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=24,'PREVISÃO DE DESPESA'!H9<36),36-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=36,'PREVISÃO DE DESPESA'!H9<48),39-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=48,'PREVISÃO DE DESPESA'!H9<60),42-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=60,'PREVISÃO DE DESPESA'!H9<72),45-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=72,'PREVISÃO DE DESPESA'!H9<84),48-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=84,'PREVISÃO DE DESPESA'!H9<96),51-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=96,'PREVISÃO DE DESPESA'!H9<108),54-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=108,'PREVISÃO DE DESPESA'!H9<120),57-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=120,'PREVISÃO DE DESPESA'!H9<132),60-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=132,'PREVISÃO DE DESPESA'!H9<144),63-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=144,'PREVISÃO DE DESPESA'!H9<156),66-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=156,'PREVISÃO DE DESPESA'!H9<168),69-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=168,'PREVISÃO DE DESPESA'!H9<180),72-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=180,'PREVISÃO DE DESPESA'!H9<192),75-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=192,'PREVISÃO DE DESPESA'!H9<204),78-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=204,'PREVISÃO DE DESPESA'!H9<216),81-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=216,'PREVISÃO DE DESPESA'!H9<228),84-30,\nIF(AND('PREVISÃO DE DESPESA'!H9>=228,'PREVISÃO DE DESPESA'!H9<240),87-30,\n90-30)))))))))))))))))))))","v":1500},{"$f":"+(X19*8/100)+(((X19)*(8%)*40%))","v":0},{"$f":"SUM(O19+S19+T19)+((X19+Z19)/12)","v":1466.0555555555557},{"$f":"+(IF((22*$O$11)>=C19*6%,(22*$O$11)-(C19*6%),0))*B19*V19","v":0},{"$f":"IF(V19=0,0,(30*(1+ROUNDUP(V19/12,0))*(1+20/100)))-2","v":142},{"$f":"+(F19*V19)","v":180000},{"$f":"J19*V19","v":63540},{"$f":"+AC19","v":142},{"$f":"(+AB19)","v":0},{"$f":"+((O19+S19+T19)*V19)+(X19+Z19)","v":52778},{"$f":"SUM(AD19:AH19)","v":296460},{"$f":"SUM(AD19:AE19)","v":243540}]
[{"$f":"+IF('PREVISÃO DE DESPESA'!C10=0,\" \",'PREVISÃO DE DESPESA'!C10)","v":" "},1,{"$f":"+'PREVISÃO DE DESPESA'!F10","v":0},null,null,{"$f":"+(C20+D20+E20)*B20","v":0},{"$f":"(F20)*8%","v":0},{"$f":"C20*26.3%","v":0},{"$f":"(F20)*1%","v":0},{"$f":"SUM(G20:I20)","v":0},{"$f":"F20/12","v":0},{"$f":"F20*11.11/100","v":0},{"$f":"+IF($C$10=\"NÃO\",0,IF(AND(V20>=1,V20<60),F20/12*1,IF(AND(V20>=60,V20<=168),F20/12*2,IF(AND(V20>168,V20<=240),F20/12*3,F20/12*3))))","v":0},{"$f":"+IF($C$10=\"NÃO\",0,IF(AND(V20>=1,V20<60),F20/12*1,IF(AND(V20>=60,V20<=168),F20/12*2,IF(AND(V20>168,V20<=240),F20/12*3,F20/12))))","v":0},{"$f":"SUM(K20:N20)","v":0},{"$f":"(K20+M20+(K20/3))*8%","v":0},{"$f":"(K20+(K20/3))*26.3%","v":0},{"$f":"(K20+M20+(K20/3))*1%","v":0},{"$f":"SUM(P20:R20)","v":0},{"$f":"(((F20+K20+M20+(K20/3))*(8%)*40%))","v":0},{"$f":"+F20+J20+O20+T20+S20","v":0},{"$f":"+'PREVISÃO DE DESPESA'!H10","v":0},{"$f":"+U20*V20","v":0},{"$f":"+IF($C$10=\"NÃO\",0,'PREVISÃO DE DESPESA'!F10/30*IF(+'PREVISÃO DE DESPESA'!H10<12,30,IF(AND(+'PREVISÃO DE DESPESA'!H10>=12,+'PREVISÃO DE DESPESA'!H10<24),33,IF(AND(+'PREVISÃO DE DESPESA'!H10>=24,+'PREVISÃO DE DESPESA'!H10<36),36,IF(AND(+'PREVISÃO DE DESPESA'!H10>=36,+'PREVISÃO DE DESPESA'!H10<48),39,IF(AND(+'PREVISÃO DE DESPESA'!H10>=48,+'PREVISÃO DE DESPESA'!H10<60),42,IF(AND(+'PREVISÃO DE DESPESA'!H10>=60,+'PREVISÃO DE DESPESA'!H10<72),45,IF(AND(+'PREVISÃO DE DESPESA'!H10>=72,+'PREVISÃO DE DESPESA'!H10<84),48,IF(AND(+'PREVISÃO DE DESPESA'!H10>=84,+'PREVISÃO DE DESPESA'!H10<96),51,IF(AND(+'PREVISÃO DE DESPESA'!H10>=96,+'PREVISÃO DE DESPESA'!H10<108),54,IF(AND(+'PREVISÃO DE DESPESA'!H10>=108,+'PREVISÃO DE DESPESA'!H10<120),57,IF(AND(+'PREVISÃO DE DESPESA'!H10>=120,+'PREVISÃO DE DESPESA'!H10<132),60,IF(AND(+'PREVISÃO DE DESPESA'!H10>=132,+'PREVISÃO DE DESPESA'!H10<144),63,IF(AND(+'PREVISÃO DE DESPESA'!H10>=144,+'PREVISÃO DE DESPESA'!H10<156),66,IF(AND(+'PREVISÃO DE DESPESA'!H10>=156,+'PREVISÃO DE DESPESA'!H10<168),69,IF(AND(+'PREVISÃO DE DESPESA'!H10>=168,+'PREVISÃO DE DESPESA'!H10<180),72,IF(AND(+'PREVISÃO DE DESPESA'!H10>=180,+'PREVISÃO DE DESPESA'!H10<192),75,IF(AND(+'PREVISÃO DE DESPESA'!H10>=192,+'PREVISÃO DE DESPESA'!H10<204),78,IF(AND(+'PREVISÃO DE DESPESA'!H10>=204,+'PREVISÃO DE DESPESA'!H10<216),81,IF(AND(+'PREVISÃO DE DESPESA'!H10>=216,+'PREVISÃO DE DESPESA'!H10<228),84,IF(AND(+'PREVISÃO DE DESPESA'!H10>=228,+'PREVISÃO DE DESPESA'!H10<240),87,90)))))))))))))))))))))","v":0},null,{"$f":"+(X20*8/100)+(((X20)*(8%)*40%))","v":0},{"$f":"SUM(O20+S20+T20)+((X20+Z20)/12)","v":0},{"$f":"+(IF((22*$O$11)>=C20*6%,(22*$O$11)-(C20*6%),0))*B20*V20","v":0},{"$f":"IF(V20=0,0,(30*(1+ROUNDUP(V20/12,0))*(1+20/100)))-2","v":-2},{"$f":"+(F20*V20)","v":0},{"$f":"J20*V20","v":0},{"$f":"+AC20","v":-2},{"$f":"(+AB20)","v":0},{"$f":"+((O20+S20+T20)*V20)+(X20+Z20)","v":0},{"$f":"SUM(AD20:AH20)","v":-2},{"$f":"SUM(AD20:AE20)","v":0}]
["TOTAL",{"$f":"SUM(B19:B20)","v":2},{"$f":"SUM(C19:C20)","v":5000},null,null,{"$f":"SUM(F19:F20)","v":5000},400,1315,50,1765,416.66666666666669,555.5,0,0,972.16666666666674,164.44444444444446,146.11111111111111,5.5555555555555554,316.11111111111109,177.7777777777778,{"$f":"+F21+J21+O21+T21+S21","v":8231.0555555555547},{"$f":"SUM(V19:V20)","v":36},296318,0,{"$f":"SUM(Y19:Y20)","v":1500},0,1466.0555555555557,0,140,180000,63540,140,0,52778,296458,243540]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Anos","Tempo de Serviço (Meses)","Aviso ","Projeção"]
[1,12,30,3,{"$f":"C299+D299","v":33}]
[2,{"$f":"12+B299","v":24},30,{"$f":"D299+3","v":6},36]
[3,36,30,9,39]
[4,48,30,12,42]
[5,60,30,15,45]
[6,72,30,18,48]
[7,84,30,21,51]
[8,96,30,24,54]
[9,108,30,27,57]
[10,120,30,30,60]
[11,132,30,33,63]
[12,144,30,36,66]
[13,156,31,39,70]
[14,168,32,42,74]
[15,180,33,45,78]
[16,192,34,48,82]
[17,204,35,51,86]
[18,216,36,54,90]

{"sheet":"RESUMO","index":3,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[5,1,5,3],[6,1,6,3],[7,1,7,3],[34,1,34,2],[30,1,30,2],[28,1,28,2],[16,0,16,2],[24,1,24,2],[32,1,32,2],[20,1,20,2],[31,1,31,2],[21,1,21,2],[25,1,25,2],[23,1,23,2],[29,1,29,2],[38,0,38,2],[26,1,26,2],[10,0,10,5],[37,1,37,2],[33,1,33,2],[35,1,35,2],[19,1,19,2],[18,1,18,2],[36,1,36,2],[27,1,27,2],[6,4,6,5],[13,0,13,1],[8,4,8,5],[12,0,12,5],[22,1,22,2]]}
[]
[]
[]
[]
[]
["PROGRAMA/PROJETO:",{"$f":"'PREVISÃO DA RECEITA'!E7","v":0}]
["COORDENADOR(A):",{"$f":"'PREVISÃO DA RECEITA'!E8","v":0}]
["PERÍODO DE EXECUÇÃO:",{"$f":"'PREVISÃO DA RECEITA'!E9","v":0}]
["CÓDIGO DO PROJETO:",{"$f":"'PREVISÃO DA RECEITA'!E10","v":0},"CONTA CORRENTE:",{"$f":"'PREVISÃO DA RECEITA'!L10","v":0}]
[]
["RESUMO DA PROPOSTA ORÇAMENTÁRIA"]
[]
["1.RECEITAS"]
["NOME DO ÓRGÃO FINANCIADOR",null,"ORIGEM DOS RECURSOS","VALOR"]
[{"$f":"+'PREVISÃO DA RECEITA'!A16:G16","v":"NEOENERGIA"},null,{"$f":"+'PREVISÃO DA RECEITA'!H16","v":0},{"$f":"+'PREVISÃO DA RECEITA'!O16","v":0}]
[{"$f":"+'PREVISÃO DA RECEITA'!A17:G17","v":0},null,{"$f":"+'PREVISÃO DA RECEITA'!H17","v":0},{"$f":"+'PREVISÃO DA RECEITA'!O17","v":0}]
["TOTAL DA PREVISÃO DE RECEITA",null,null,{"$f":"SUM(D15:D16)","v":0}]
["2. DESPESAS"]
["CÓDIGO","CATEGORIA",null,"VALOR"]
["30.00.00","Despesas Operacionais",null,{"$f":"SUM(D21+D25)","v":330839.04700000002}]
["31.90.00","Pessoal e encargos Sociais",null,{"$f":"SUM(D22:D24)","v":296318}]
["31.90.11","Despesas com Pessoal",null,{"$f":"+'PREVISÃO DE DESPESA'!I11","v":180000}]
["31.90.13","Encargos Sociais",null,{"$f":"+'PREVISÃO DE DESPESA'!I17","v":63540}]
["99.99.99","Obrigações Patronais sobre Férias, 13º  Salário e Rescisão Contratual",null,{"$f":"'PREVISÃO DE DESPESA'!I23","v":52778}]
["33.90.00","Outras Despesas Operacionais",null,{"$f":"SUM(D26:D34)","v":34521.047000000006}]
["33.90.14","Diárias Pessoal ",null,{"$f":"+'PREVISÃO DE DESPESA'!I77","v":0}]
["33.90.18","Bolsa Estágio e Auxilio Financeiro a Estudantes ",null,{"$f":"+'PREVISÃO DE DESPESA'!I43+'PREVISÃO DE DESPESA'!I58","v":0}]
["33.90.20","Bolsa de Ensino, Pesquisa e Extensão",null,{"$f":"+'PREVISÃO DE DESPESA'!I34","v":0}]
["33.90.30","Material de Consumo",null,{"$f":"+'PREVISÃO DE DESPESA'!I91","v":0}]
["33.90.33","Passagens e Despesas com Locomoção",null,{"$f":"+'PREVISÃO DE DESPESA'!I84","v":0}]
["33.90.36","Outros Serviços de Terceiros Pessoa Física",null,{"$f":"+'PREVISÃO DE DESPESA'!I70","v":0}]
["33.90.39","Outros Serviços de Terceiros Pessoa Jurídica",null,{"$f":"+'PREVISÃO DE DESPESA'!I98+'PREVISÃO DE DESPESA'!I124+'PREVISÃO DE DESPESA'!I51","v":34521.047000000006}]
["33.90.41","Contribuições ",null,{"$f":"+'PREVISÃO DE DESPESA'!I130","v":0}]
["33.90.47","Obrigações Tributárias e Contributivas",null,{"$f":"+'PREVISÃO DE DESPESA'!I118","v":0}]
["40.00.00","Investimentos",null,{"$f":"SUM(D36)","v":0}]
["44.90.00","Investimentos",null,{"$f":"SUM(D37:D38)","v":0}]
["44.90.51","Obras e Instalações",null,{"$f":"+'PREVISÃO DE DESPESA'!I106","v":0}]
["44.90.52","Equipamentos e Material Permanente",null,{"$f":"+'PREVISÃO DE DESPESA'!I113","v":0}]
["TOTAL DA PREVISÃO DE DESPESAS E INVESTIMENTOS",null,null,{"$f":"SUM(D20+D35)","v":330839.04700000002}]

{"sheet":"ACOMPANHAMENTO 1","index":4,"n_rows":131,"n_cols":25,"rows_kept":131,"cut":false,"hidden":true,"merged":[[100,10,100,11],[101,10,101,11],[101,12,101,13],[98,12,98,13],[99,12,99,13],[100,12,100,13],[97,10,97,11],[65,12,65,13],[66,10,66,11],[66,12,66,13],[67,10,67,11],[67,12,67,13],[72,10,72,11],[72,12,72,13],[73,10,73,11],[73,12,73,13],[77,12,77,13],[78,12,78,13],[79,12,79,13],[80,12,80,13],[74,10,74,11],[75,10,75,11],[76,10,76,11],[77,10,77,11],[44,4,44,7],[44,10,44,11],[50,12,50,13],[50,4,50,7],[51,12,51,13],[52,12,52,13],[51,4,51,7],[52,4,52,7],[47,10,47,11],[47,12,47,13],[48,12,48,13],[49,10,49,11],[49,12,49,13],[45,8,45,9],[45,12,45,13],[46,10,46,11],[46,4,46,7],[49,4,49,7],[45,4,45,7],[51,10,51,11],[82,4,82,7],[73,4,73,7],[72,4,72,7],[75,4,75,7],[54,4,54,7],[54,10,54,11],[55,10,55,11],[57,8,57,9],[64,8,64,9],[58,8,58,9],[64,4,64,7],[64,10,64,11],[55,4,55,7],[56,4,56,7],[54,8,54,9],[55,8,55,9],[56,8,56,9],[69,10,69,11],[58,4,58,7],[77,4,77,7],[81,10,81,11],[82,8,82,9],[81,12,81,13],[70,4,70,7],[71,4,71,7],[68,8,68,9],[71,10,71,11],[71,12,71,13],[81,4,81,7],[79,10,79,11],[80,10,80,11],[79,4,79,7],[80,4,80,7],[78,10,78,11],[70,10,70,11],[68,12,68,13],[69,12,69,13],[76,4,76,7],[74,4,74,7],[73,8,73,9],[74,8,74,9],[78,4,78,7],[81,8,81,9],[77,8,77,9],[78,8,78,9],[75,12,75,13],[99,4,99,7],[100,4,100,7],[91,12,91,13],[88,4,88,7],[89,4,89,7],[88,12,88,13],[93,12,93,13],[91,4,91,7],[90,4,90,7],[90,10,90,11],[92,4,92,7],[88,10,88,11],[89,12,89,13],[99,10,99,11],[96,8,96,9],[95,10,95,11],[90,12,90,13],[96,12,96,13],[97,4,97,7],[96,10,96,11],[95,12,95,13],[95,4,95,7],[91,10,91,11],[94,4,94,7],[0,1,0,2],[1,1,1,2],[19,4,19,7],[20,4,20,7],[13,0,13,13],[6,0,7,0],[6,3,7,3],[6,2,7,2],[6,1,7,1],[5,0,5,8],[17,4,17,7],[18,4,18,7],[16,12,16,13],[17,10,17,11],[16,0,16,1],[17,12,17,13],[16,8,16,9],[18,12,18,13],[16,4,16,7],[16,10,16,11],[17,8,17,9],[18,10,18,11],[6,4,6,8],[18,8,18,9],[43,4,43,7],[42,4,42,7],[41,8,41,9],[41,10,41,11],[25,8,25,9],[26,8,26,9],[22,8,22,9],[20,8,20,9],[21,8,21,9],[23,8,23,9],[24,8,24,9],[22,10,22,11],[25,4,25,7],[24,4,24,7],[31,4,31,7],[34,4,34,7],[30,4,30,7],[41,4,41,7],[32,8,32,9],[33,8,33,9],[37,0,37,13],[34,8,34,9],[27,12,27,13],[27,10,27,11],[40,0,40,1],[40,4,40,7],[32,4,32,7],[19,12,19,13],[20,12,20,13],[19,8,19,9],[21,4,21,7],[22,4,22,7],[23,4,23,7],[27,4,27,7],[26,4,26,7],[32,12,32,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[32,10,32,11],[30,10,30,11],[31,10,31,11],[29,8,29,9],[29,10,29,11],[40,10,40,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[28,10,28,11],[33,12,33,13],[33,10,33,11],[34,0,34,1],[33,4,33,7],[29,4,29,7],[28,4,28,7],[21,12,21,13],[26,10,26,11],[30,8,30,9],[31,8,31,9],[27,8,27,9],[28,8,28,9],[24,12,24,13],[25,10,25,11],[25,12,25,13],[24,10,24,11],[26,12,26,13],[28,12,28,13],[22,12,22,13],[23,12,23,13],[23,10,23,11],[76,12,76,13],[74,12,74,13],[66,8,66,9],[57,4,57,7],[53,4,53,7],[65,4,65,7],[61,0,61,13],[64,0,64,1],[57,10,57,11],[66,4,66,7],[67,4,67,7],[75,8,75,9],[76,8,76,9],[56,10,56,11],[53,8,53,9],[67,8,67,9],[72,8,72,9],[99,8,99,9],[100,8,100,9],[88,0,88,1],[68,10,68,11],[46,8,46,9],[47,8,47,9],[48,8,48,9],[68,4,68,7],[69,4,69,7],[47,4,47,7],[82,0,82,1],[48,4,48,7],[58,0,58,1],[49,8,49,9],[50,10,50,11],[69,8,69,9],[70,8,70,9],[79,8,79,9],[80,8,80,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[71,8,71,9],[65,8,65,9],[40,12,40,13],[43,12,43,13],[44,8,44,9],[70,12,70,13],[52,10,52,11],[53,10,53,11],[40,8,40,9],[45,10,45,11],[42,8,42,9],[43,8,43,9],[41,12,41,13],[64,12,64,13],[65,10,65,11],[57,12,57,13],[48,10,48,11],[53,12,53,13],[54,12,54,13],[55,12,55,13],[56,12,56,13],[42,12,42,13],[43,10,43,11],[42,10,42,11],[46,12,46,13],[44,12,44,13],[95,8,95,9],[98,8,98,9],[85,0,85,13],[88,8,88,9],[89,8,89,9],[90,8,90,9],[97,8,97,9],[98,4,98,7],[98,10,98,11],[96,4,96,7],[89,10,89,11],[94,10,94,11],[92,10,92,11],[92,12,92,13],[97,12,97,13],[93,4,93,7],[93,10,93,11],[91,8,91,9],[92,8,92,9],[93,8,93,9],[94,12,94,13],[94,8,94,9],[112,0,112,1],[112,4,112,7],[112,8,112,9],[112,10,112,11],[102,8,102,9],[103,8,103,9],[104,8,104,9],[105,8,105,9],[110,4,110,7],[110,8,110,9],[106,0,106,1],[109,0,109,13],[104,12,104,13],[105,10,105,11],[105,12,105,13],[106,4,106,7],[106,8,106,9],[105,4,105,7],[104,4,104,7],[104,10,104,11],[103,10,103,11],[103,12,103,13],[102,10,102,11],[102,12,102,13],[112,12,112,13],[113,4,113,7],[113,8,113,9],[113,10,113,11],[117,4,117,7],[117,8,117,9],[117,10,117,11],[117,12,117,13],[101,4,101,7],[103,4,103,7],[102,4,102,7],[101,8,101,9],[118,4,118,7],[118,8,118,9],[118,10,118,11],[118,12,118,13],[113,12,113,13],[115,4,115,7],[115,8,115,9],[115,10,115,11],[115,12,115,13],[116,4,116,7],[116,8,116,9],[116,10,116,11],[116,12,116,13],[114,4,114,7],[114,8,114,9],[114,10,114,11],[114,12,114,13],[121,4,121,7],[121,8,121,9],[121,10,121,11],[121,12,121,13],[122,4,122,7],[122,8,122,9],[122,10,122,11],[122,12,122,13],[119,4,119,7],[119,8,119,9],[119,10,119,11],[119,12,119,13],[120,4,120,7],[120,8,120,9],[120,10,120,11],[120,12,120,13],[125,4,125,7],[125,8,125,9],[125,10,125,11],[125,12,125,13],[126,4,126,7],[126,8,126,9],[126,10,126,11],[126,12,126,13],[123,4,123,7],[123,8,123,9],[123,10,123,11],[123,12,123,13],[124,4,124,7],[124,8,124,9],[124,10,124,11],[124,12,124,13],[130,0,130,1],[130,4,130,7],[130,8,130,9],[129,4,129,7],[129,8,129,9],[127,4,127,7],[127,8,127,9],[127,10,127,11],[127,12,127,13],[129,12,129,13],[128,4,128,7],[128,8,128,9],[128,10,128,11],[128,12,128,13],[129,10,129,11]]}
["DATA INÍCIO","2006-08-01"]
["DATA FIM","2007-08-01"]
["VIGÊNCIA",{"$f":"dias(B1,B2)","v":365},"dias"]
[]
[]
["CRONOGRAMA DE DESEMBOLSO"]
["DATA","VALOR","DATA DE RECEB.","VALOR RECEBIDO","PERÍODOS",null,null,null,null,null,null,3]
[null,null,null,null,1,2,3,4,5,null,null,null,null,null,null,1,2,3,4,5,"valor1","valor2","valor3","valor4","valor5"]
["2006-08-01",1000,"2006-08-01",1000,"X","X","X","X",null,{"$f":"J8+1","v":1},null,null,null,null,null,{"$f":"IF(AND($C9<=$B$16,NOT(ISBLANK($C9)),UPPER(E9)=\"X\"),1,0)","v":1},{"$f":"IF(AND($C9<=$B$40,NOT(ISBLANK($C9)),UPPER(F9)=\"X\"),1,0)","v":1},{"$f":"IF(AND($C9<=$B$64,NOT(ISBLANK($C9)),UPPER(G9)=\"X\"),1,0)","v":1},{"$f":"IF(AND($C9<=$B$88,NOT(ISBLANK($C9)),UPPER(H9)=\"X\"),1,0)","v":1},{"$f":"IF(AND($C9<=$B$112,NOT(ISBLANK($C9)),UPPER(I9)=\"X\"),1,0)","v":0},{"$f":"IF(SUM($P9:$S9)=0,0,$D9/SUM($P9:$S9)*P9)","v":250},250,250,250,{"$f":"IF($T9=0,0,$D9*$T9)","v":0}]
["2006-10-10",700,"2006-10-10",700,"X","X","X","X",null,{"$f":"J9+1","v":2},null,null,null,null,null,{"$f":"IF(AND($C10<=$B$16,NOT(ISBLANK($C10)),UPPER(E10)=\"X\"),1,0)","v":1},{"$f":"IF(AND($C10<=$B$40,NOT(ISBLANK($C10)),UPPER(F10)=\"X\"),1,0)","v":1},{"$f":"IF(AND($C10<=$B$64,NOT(ISBLANK($C10)),UPPER(G10)=\"X\"),1,0)","v":1},{"$f":"IF(AND($C10<=$B$88,NOT(ISBLANK($C10)),UPPER(H10)=\"X\"),1,0)","v":1},{"$f":"IF(AND($C10<=$B$112,NOT(ISBLANK($C10)),UPPER(I10)=\"X\"),1,0)","v":0},175,175,175,175,{"$f":"IF($T10=0,0,$D10*$T10)","v":0}]
["2007-08-10",20,"2007-08-10",10,null,null,null,null,"X",{"$f":"J10+1","v":3},null,null,null,null,null,{"$f":"IF(AND($C11<=$B$16,NOT(ISBLANK($C11)),UPPER(E11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$40,NOT(ISBLANK($C11)),UPPER(F11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$64,NOT(ISBLANK($C11)),UPPER(G11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$88,NOT(ISBLANK($C11)),UPPER(H11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$112,NOT(ISBLANK($C11)),UPPER(I11)=\"X\"),1,0)","v":1},0,0,0,0,{"$f":"IF($T11=0,0,$D11*$T11)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total",{"$f":"SUM(U9:U11)","v":425},{"$f":"SUM(V9:V11)","v":425},{"$f":"SUM(W9:W11)","v":425},{"$f":"SUM(X9:X11)","v":425},{"$f":"SUM(Y9:Y11)","v":10}]
[]
["ACOMPANHAMENTO FÍSICO-FINANCEIRO"]
["PERÍODO 1:  0% a 25% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.25*$B$3+$B$1","v":"2006-10-31T06:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
["PESSOAL + ENCARGOS",null,{"$f":"'PREVISÃO DE DESPESA'!I25","v":296318},{"$f":"IF(ISERR(C18/SUM($C$18:$C$34)*$U$12),\"\",C18/SUM($C$18:$C$34)*$U$12)","v":""},null,null,null,null,{"$f":"IF(ISERR(D18-E18),\"\",D18-E18)","v":""}]
["BOLSA ACADÊMICA",null,{"$f":"totalRubrica02","v":0},"",null,null,null,null,{"$f":"IF(ISERR(D19-E19),\"\",D19-E19)","v":""}]
["BOLSA ESTUDANTE",null,{"$f":"totalRubrica03","v":0},"",null,null,null,null,""]
["PESSOA FÍSICA",null,{"$f":"totalRubrica04","v":0},"",null,null,null,null,""]
["DIÁRIAS",null,{"$f":"totalRubrica05","v":0},"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,{"$f":"totalRubrica06","v":0},"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,{"$f":"totalRubrica07","v":0},"",null,null,null,null,""]
["PESSOA JURÍDICA",null,{"$f":"totalRubrica08","v":0},"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,{"$f":"totalRubrica09","v":0},"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,{"$f":"totalRubrica10","v":0},"",null,null,null,null,""]
["INSS EMPRESA",null,{"$f":"totalRubrica12","v":0},"",null,null,null,null,""]
["CPMF / TARIFAS",null,{"$f":"totalRubrica13","v":4889.2469999999994},"",null,null,null,null,""]
["FUNDEPES",null,{"$f":"totalRubrica14","v":29631.800000000003},"",null,null,null,null,""]
["UFAL",null,{"$f":"totalRubrica15","v":0},"",null,null,null,null,""]
["DEPARTAMENTO",null,{"$f":"totalRubrica16","v":0},"",null,null,null,null,""]
["FCPT",null,{"$f":"totalRubrica17","v":{"$error":"#REF!"}},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$f":"totalRubrica18","v":{"$error":"#REF!"}},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C18:C34)","v":{"$error":"#REF!"}},{"$f":"SUM(D18:D34)","v":0},{"$f":"SUM(E18:E34)","v":0},null,null,null,{"$f":"SUM(I18:J34)","v":0}]
[]
[]
[{"$f":"A14","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 2:  25% a 50% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.5*$B$3+$B$1","v":"2007-01-30T12:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A18","v":"PESSOAL + ENCARGOS"},null,{"$f":"C18","v":296318},{"$f":"IF(ISERR(C42/SUM($C$42:$C$58)*$V$12+I18),\"\",C42/SUM($C$42:$C$58)*$V$12+I18)","v":""},null,null,null,null,{"$f":"IF(ISERR(D42-E42),\"\",D42-E42)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C43/SUM($C$42:$C$58)*$V$12+I19),\"\",C43/SUM($C$42:$C$58)*$V$12+I19)","v":""},null,null,null,null,{"$f":"IF(ISERR(D43-E43),\"\",D43-E43)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C42:C58)","v":{"$error":"#REF!"}},{"$f":"SUM(D42:D58)","v":0},{"$f":"SUM(E42:H58)","v":0},null,null,null,{"$f":"SUM(I42:J58)","v":0},{"$f":"SUM(J42:J58)","v":0}]
[]
[]
[{"$f":"A38","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 3:  50% a 75% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.75*$B$3+$B$1","v":"2007-05-01T18:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A18","v":"PESSOAL + ENCARGOS"},null,{"$f":"C18","v":296318},{"$f":"IF(ISERR(C66/SUM($C$66:$C$82)*$W$12+I42),\"\",C66/SUM($C$66:$C$82)*$W$12+I42)","v":""},null,null,null,null,{"$f":"IF(ISERR(D66-E66),\"\",D66-E66)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C67/SUM($C$66:$C$82)*$W$12+I43),\"\",C67/SUM($C$66:$C$82)*$W$12+I43)","v":""},null,null,null,null,{"$f":"IF(ISERR(D67-E67),\"\",D67-E67)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C66:C82)","v":{"$error":"#REF!"}},{"$f":"SUM(D66:D82)","v":0},{"$f":"SUM(E66:H82)","v":0},null,null,null,{"$f":"SUM(I66:J82)","v":0},{"$f":"SUM(J66:J82)","v":0}]
[]
[]
[{"$f":"A62","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 4:  75% a 100% do tempo de projeto"]
["DATA LIMITE:",{"$f":"1*$B$3+$B$1","v":"2007-08-01"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A18","v":"PESSOAL + ENCARGOS"},null,{"$f":"C18","v":296318},{"$f":"IF(ISERR(C90/SUM($C$90:$C$106)*$X$12+I66),\"\",C90/SUM($C$90:$C$106)*$X$12+I66)","v":""},null,null,null,null,{"$f":"IF(ISERR(D90-E90),\"\",D90-E90)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C91/SUM($C$90:$C$106)*$X$12+I67),\"\",C91/SUM($C$90:$C$106)*$X$12+I67)","v":""},null,null,null,null,{"$f":"IF(ISERR(D91-E91),\"\",D91-E91)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C90:C106)","v":{"$error":"#REF!"}},{"$f":"SUM(D90:D106)","v":0},{"$f":"SUM(E90:H106)","v":0},null,null,null,{"$f":"SUM(I90:J106)","v":0},{"$f":"SUM(J90:J106)","v":0}]
[]
[]
[{"$f":"A86","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 5",null,null,"Tempo Complementar: ",60,null,null,null," dias"]
["DATA LIMITE:",{"$f":"1*$B$3+$B$1+E111","v":"2007-09-30"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A42","v":"PESSOAL + ENCARGOS"},null,{"$f":"C42","v":296318},{"$f":"IF(ISERR(C114/SUM($C$114:$C$130)*$Y$12+I90),\"\",C114/SUM($C$114:$C$130)*$Y$12+I90)","v":""},null,null,null,null,{"$f":"IF(ISERR(D114-E114),\"\",D114-E114)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C115/SUM($C$114:$C$130)*$Y$12+I91),\"\",C115/SUM($C$114:$C$130)*$Y$12+I91)","v":""},null,null,null,null,{"$f":"IF(ISERR(D115-E115),\"\",D115-E115)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C114:C130)","v":{"$error":"#REF!"}},{"$f":"SUM(D114:D130)","v":0},{"$f":"SUM(E114:H130)","v":0},null,null,null,{"$f":"SUM(I114:J130)","v":0},{"$f":"SUM(J114:J130)","v":0}]

{"sheet":"ACOMPANHAMENTO 2","index":5,"n_rows":203,"n_cols":33,"rows_kept":203,"cut":false,"hidden":true,"merged":[[201,14,201,15],[200,4,200,7],[200,8,200,11],[202,0,202,1],[202,4,202,7],[202,8,202,11],[201,4,201,7],[201,8,201,11],[201,12,201,13],[200,12,200,13],[200,14,200,15],[198,4,198,7],[198,8,198,11],[198,12,198,13],[198,14,198,15],[199,4,199,7],[199,8,199,11],[199,12,199,13],[199,14,199,15],[195,4,195,7],[195,8,195,11],[195,12,195,13],[195,14,195,15],[194,4,194,7],[194,8,194,11],[194,12,194,13],[194,14,194,15],[197,4,197,7],[197,8,197,11],[197,12,197,13],[197,14,197,15],[196,4,196,7],[196,8,196,11],[196,12,196,13],[196,14,196,15],[191,4,191,7],[191,8,191,11],[191,12,191,13],[191,14,191,15],[190,4,190,7],[190,8,190,11],[190,12,190,13],[190,14,190,15],[193,4,193,7],[193,8,193,11],[193,12,193,13],[193,14,193,15],[192,4,192,7],[192,8,192,11],[192,12,192,13],[192,14,192,15],[187,4,187,7],[187,8,187,11],[187,12,187,13],[187,14,187,15],[186,4,186,7],[186,8,186,11],[186,12,186,13],[186,14,186,15],[189,4,189,7],[189,8,189,11],[189,12,189,13],[189,14,189,15],[188,4,188,7],[188,8,188,11],[188,12,188,13],[188,14,188,15],[185,4,185,7],[185,8,185,11],[185,12,185,13],[185,14,185,15],[177,14,177,15],[181,0,181,15],[184,0,184,1],[184,4,184,7],[184,8,184,11],[184,12,184,13],[178,0,178,1],[178,4,178,7],[178,8,178,11],[176,14,176,15],[174,4,174,7],[174,8,174,11],[174,12,174,13],[174,14,174,15],[184,14,184,15],[173,4,173,7],[173,8,173,11],[173,12,173,13],[173,14,173,15],[175,4,175,7],[175,8,175,11],[177,4,177,7],[177,8,177,11],[177,12,177,13],[175,12,175,13],[176,4,176,7],[176,8,176,11],[176,12,176,13],[172,4,172,7],[172,8,172,11],[172,12,172,13],[172,14,172,15],[175,14,175,15],[169,4,169,7],[169,8,169,11],[169,12,169,13],[169,14,169,15],[168,4,168,7],[168,8,168,11],[168,12,168,13],[168,14,168,15],[171,4,171,7],[171,8,171,11],[171,12,171,13],[171,14,171,15],[170,4,170,7],[170,8,170,11],[170,12,170,13],[170,14,170,15],[165,4,165,7],[165,8,165,11],[165,12,165,13],[165,14,165,15],[164,4,164,7],[164,8,164,11],[164,12,164,13],[164,14,164,15],[167,4,167,7],[167,8,167,11],[167,12,167,13],[167,14,167,15],[166,4,166,7],[166,8,166,11],[166,12,166,13],[166,14,166,15],[161,4,161,7],[161,8,161,11],[161,12,161,13],[161,14,161,15],[160,0,160,1],[160,4,160,7],[160,8,160,11],[160,12,160,13],[163,4,163,7],[163,8,163,11],[163,12,163,13],[163,14,163,15],[162,4,162,7],[162,8,162,11],[162,12,162,13],[162,14,162,15],[154,0,154,1],[154,4,154,7],[154,8,154,11],[157,0,157,15],[160,14,160,15],[152,4,152,7],[152,8,152,11],[152,12,152,13],[152,14,152,15],[153,4,153,7],[150,4,150,7],[150,8,150,11],[150,12,150,13],[150,14,150,15],[149,4,149,7],[149,8,149,11],[149,12,149,13],[149,14,149,15],[153,8,153,11],[153,12,153,13],[153,14,153,15],[151,4,151,7],[151,8,151,11],[151,12,151,13],[151,14,151,15],[148,4,148,7],[148,8,148,11],[148,12,148,13],[148,14,148,15],[146,12,146,13],[146,14,146,15],[147,4,147,7],[147,8,147,11],[147,12,147,13],[147,14,147,15],[146,4,146,7],[146,8,146,11],[130,0,130,1],[130,4,130,7],[129,4,129,7],[129,14,129,15],[128,4,128,7],[128,12,128,13],[128,14,128,15],[126,4,126,7],[126,12,126,13],[126,14,126,15],[96,8,96,11],[97,8,97,11],[45,8,45,11],[46,8,46,11],[103,8,103,11],[23,8,23,11],[24,8,24,11],[25,8,25,11],[26,8,26,11],[27,8,27,11],[28,8,28,11],[29,8,29,11],[40,8,40,11],[41,8,41,11],[125,4,125,7],[125,12,125,13],[125,14,125,15],[30,8,30,11],[31,8,31,11],[32,8,32,11],[33,8,33,11],[34,8,34,11],[47,8,47,11],[48,8,48,11],[124,4,124,7],[124,12,124,13],[124,14,124,15],[49,8,49,11],[50,8,50,11],[51,8,51,11],[52,8,52,11],[53,8,53,11],[54,8,54,11],[55,8,55,11],[123,4,123,7],[42,8,42,11],[43,8,43,11],[113,8,113,11],[123,12,123,13],[123,14,123,15],[56,8,56,11],[57,8,57,11],[58,8,58,11],[64,8,64,11],[65,8,65,11],[66,8,66,11],[67,8,67,11],[98,8,98,11],[75,8,75,11],[76,8,76,11],[96,14,96,15],[97,12,97,13],[97,14,97,15],[102,14,102,15],[101,14,101,15],[99,12,99,13],[100,12,100,13],[98,12,98,13],[101,12,101,13],[91,12,91,13],[94,12,94,13],[75,12,75,13],[122,4,122,7],[122,12,122,13],[122,14,122,15],[68,8,68,11],[69,8,69,11],[70,8,70,11],[71,8,71,11],[72,8,72,11],[73,8,73,11],[74,8,74,11],[79,8,79,11],[80,8,80,11],[115,14,115,15],[119,14,119,15],[99,8,99,11],[121,4,121,7],[121,12,121,13],[100,8,100,11],[120,4,120,7],[120,12,120,13],[119,4,119,7],[117,4,117,7],[101,8,101,11],[102,8,102,11],[102,4,102,7],[118,4,118,7],[119,8,119,11],[100,4,100,7],[99,4,99,7],[114,4,114,7],[113,4,113,7],[101,4,101,7],[104,4,104,7],[103,4,103,7],[118,8,118,11],[106,8,106,11],[114,8,114,11],[112,0,112,1],[112,4,112,7],[112,12,112,13],[112,14,112,15],[106,4,106,7],[106,0,106,1],[105,4,105,7],[117,14,117,15],[116,4,116,7],[116,12,116,13],[116,8,116,11],[112,8,112,11],[115,4,115,7],[116,14,116,15],[113,12,113,13],[105,8,105,11],[113,14,113,15],[114,14,114,15],[136,14,136,15],[105,12,105,13],[121,8,121,11],[120,8,120,11],[118,12,118,13],[115,12,115,13],[119,12,119,13],[114,12,114,13],[117,12,117,13],[115,8,115,11],[117,8,117,11],[118,14,118,15],[105,14,105,15],[120,14,120,15],[121,14,121,15],[129,12,129,13],[128,8,128,11],[129,8,129,11],[127,14,127,15],[130,8,130,11],[133,0,133,15],[136,0,136,1],[136,4,136,7],[136,8,136,11],[139,12,139,13],[139,14,139,15],[138,4,138,7],[138,8,138,11],[138,12,138,13],[138,14,138,15],[139,4,139,7],[139,8,139,11],[137,12,137,13],[137,14,137,15],[137,4,137,7],[137,8,137,11],[142,4,142,7],[142,8,142,11],[142,12,142,13],[142,14,142,15],[143,4,143,7],[143,8,143,11],[141,12,141,13],[141,14,141,15],[140,4,140,7],[140,8,140,11],[140,12,140,13],[140,14,140,15],[141,4,141,7],[141,8,141,11],[145,12,145,13],[145,14,145,15],[144,4,144,7],[144,8,144,11],[144,12,144,13],[144,14,144,15],[145,4,145,7],[145,8,145,11],[143,12,143,13],[143,14,143,15],[70,4,70,7],[71,4,71,7],[94,4,94,7],[91,4,91,7],[77,4,77,7],[127,4,127,7],[109,0,109,15],[103,12,103,13],[98,4,98,7],[127,12,127,13],[123,8,123,11],[124,8,124,11],[125,8,125,11],[126,8,126,11],[122,8,122,11],[127,8,127,11],[104,14,104,15],[98,14,98,15],[99,14,99,15],[100,14,100,15],[103,14,103,15],[95,14,95,15],[91,8,91,11],[104,8,104,11],[136,12,136,13],[41,4,41,7],[76,4,76,7],[74,4,74,7],[68,4,68,7],[69,4,69,7],[56,4,56,7],[48,4,48,7],[43,4,43,7],[66,4,66,7],[67,4,67,7],[65,4,65,7],[65,12,65,13],[81,12,81,13],[72,4,72,7],[80,4,80,7],[95,12,95,13],[104,12,104,13],[102,12,102,13],[96,12,96,13],[82,8,82,11],[88,8,88,11],[89,8,89,11],[90,8,90,11],[24,4,24,7],[47,4,47,7],[42,14,42,15],[43,12,43,13],[45,12,45,13],[37,0,37,15],[44,14,44,15],[44,4,44,7],[95,8,95,11],[64,0,64,1],[91,14,91,15],[92,12,92,13],[92,14,92,15],[73,4,73,7],[75,4,75,7],[89,14,89,15],[72,14,72,15],[75,14,75,15],[82,0,82,1],[93,4,93,7],[90,14,90,15],[80,14,80,15],[81,14,81,15],[80,12,80,13],[47,12,47,13],[50,12,50,13],[42,4,42,7],[56,14,56,15],[51,14,51,15],[52,14,52,15],[55,4,55,7],[55,12,55,13],[52,12,52,13],[53,12,53,13],[51,4,51,7],[56,12,56,13],[45,14,45,15],[53,14,53,15],[54,14,54,15],[55,14,55,15],[44,8,44,11],[23,4,23,7],[31,4,31,7],[49,4,49,7],[27,4,27,7],[30,4,30,7],[26,4,26,7],[28,4,28,7],[16,14,16,15],[17,12,17,13],[17,14,17,15],[16,12,16,13],[17,4,17,7],[16,4,16,7],[16,8,16,11],[17,8,17,11],[18,14,18,15],[19,14,19,15],[20,14,20,15],[19,4,19,7],[20,4,20,7],[18,12,18,13],[19,12,19,13],[20,12,20,13],[18,4,18,7],[0,1,0,2],[1,1,1,2],[21,4,21,7],[22,4,22,7],[5,0,5,11],[6,4,6,11],[6,0,7,0],[6,3,7,3],[6,2,7,2],[6,1,7,1],[16,0,16,1],[18,8,18,11],[13,0,13,15],[22,8,22,11],[19,8,19,11],[20,8,20,11],[21,8,21,11],[21,14,21,15],[22,14,22,15],[96,4,96,7],[97,4,97,7],[54,4,54,7],[81,4,81,7],[90,4,90,7],[82,4,82,7],[95,4,95,7],[89,4,89,7],[57,14,57,15],[64,4,64,7],[64,12,64,13],[58,4,58,7],[64,14,64,15],[57,4,57,7],[57,12,57,13],[61,0,61,15],[58,0,58,1],[81,8,81,11],[78,4,78,7],[79,4,79,7],[88,14,88,15],[88,12,88,13],[89,12,89,13],[93,14,93,15],[40,0,40,1],[40,4,40,7],[25,4,25,7],[34,4,34,7],[34,0,34,1],[66,12,66,13],[66,14,66,15],[67,12,67,13],[67,14,67,15],[47,14,47,15],[48,14,48,15],[49,12,49,13],[49,14,49,15],[48,12,48,13],[42,12,42,13],[27,14,27,15],[27,12,27,13],[25,14,25,15],[52,4,52,7],[53,4,53,7],[46,4,46,7],[50,4,50,7],[45,4,45,7],[33,14,33,15],[23,14,23,15],[26,14,26,15],[74,14,74,15],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[65,14,65,15],[72,12,72,13],[73,12,73,13],[73,14,73,15],[71,12,71,13],[68,14,68,15],[69,14,69,15],[24,14,24,15],[41,12,41,13],[41,14,41,15],[25,12,25,13],[33,12,33,13],[40,12,40,13],[40,14,40,15],[26,12,26,13],[74,12,74,13],[46,14,46,15],[77,12,77,13],[76,12,76,13],[85,0,85,15],[88,0,88,1],[76,14,76,15],[77,14,77,15],[78,14,78,15],[79,14,79,15],[77,8,77,11],[92,4,92,7],[78,12,78,13],[88,4,88,7],[79,12,79,13],[94,14,94,15],[93,12,93,13],[92,8,92,11],[93,8,93,11],[94,8,94,11],[78,8,78,11],[90,12,90,13],[32,4,32,7],[28,14,28,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[28,12,28,13],[29,4,29,7],[70,14,70,15],[71,14,71,15],[69,12,69,13],[31,12,31,13],[32,14,32,15],[29,12,29,13],[32,12,32,13],[51,12,51,13],[70,12,70,13],[54,12,54,13],[68,12,68,13],[33,4,33,7],[30,12,30,13],[50,14,50,15],[43,14,43,15],[44,12,44,13],[46,12,46,13]]}
["DATA INÍCIO","2006-08-01"]
["DATA FIM","2007-08-01"]
["VIGÊNCIA",{"$f":"dias(B1,B2)","v":365},"dias"]
[]
[]
["CRONOGRAMA DE DESEMBOLSO"]
["DATA","VALOR","DATA DE RECEB.","VALOR RECEBIDO","PERÍODOS",null,null,null,null,null,null,null,null,3]
[null,null,null,null,1,2,3,4,5,6,7,8,null,null,null,null,null,1,2,3,4,5,6,7,8,"valor1","valor2","valor3","valor4","valor5","valor6","valor7","valor8"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M8+1","v":1},null,null,null,null,{"$f":"IF(AND($C9<=$B$16,NOT(ISBLANK($C9)),UPPER(E9)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C9<=$B$40,NOT(ISBLANK($C9)),UPPER(F9)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C9<=$B$64,NOT(ISBLANK($C9)),UPPER(G9)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C9<=$B$88,NOT(ISBLANK($C9)),UPPER(H9)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C9<=$B$112,NOT(ISBLANK($C9)),UPPER(I9)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C9<=$B$136,NOT(ISBLANK($C9)),UPPER(J9)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C9<=$B$160,NOT(ISBLANK($C9)),UPPER(K9)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C9<=$B$184,NOT(ISBLANK($C9)),UPPER(L9)=\"X\"),1,0)","v":0},{"$f":"IF(SUM($R9:$Y9)=0,0,$D9/SUM($R9:$Y9)*R9)","v":0},0,{"$f":"IF(SUM($R9:$Y9)=0,0,$D9/SUM($R9:$Y9)*T9)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M9+1","v":2},null,null,null,null,{"$f":"IF(AND($C10<=$B$16,NOT(ISBLANK($C10)),UPPER(E10)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C10<=$B$40,NOT(ISBLANK($C10)),UPPER(F10)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C10<=$B$64,NOT(ISBLANK($C10)),UPPER(G10)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C10<=$B$88,NOT(ISBLANK($C10)),UPPER(H10)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C10<=$B$112,NOT(ISBLANK($C10)),UPPER(I10)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C10<=$B$136,NOT(ISBLANK($C10)),UPPER(J10)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C10<=$B$160,NOT(ISBLANK($C10)),UPPER(K10)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C10<=$B$184,NOT(ISBLANK($C10)),UPPER(L10)=\"X\"),1,0)","v":0},0,0,{"$f":"IF(SUM($R10:$Y10)=0,0,$D10/SUM($R10:$Y10)*T10)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M10+1","v":3},null,null,null,null,{"$f":"IF(AND($C11<=$B$16,NOT(ISBLANK($C11)),UPPER(E11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$40,NOT(ISBLANK($C11)),UPPER(F11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$64,NOT(ISBLANK($C11)),UPPER(G11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$88,NOT(ISBLANK($C11)),UPPER(H11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$112,NOT(ISBLANK($C11)),UPPER(I11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$136,NOT(ISBLANK($C11)),UPPER(J11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$160,NOT(ISBLANK($C11)),UPPER(K11)=\"X\"),1,0)","v":0},{"$f":"IF(AND($C11<=$B$184,NOT(ISBLANK($C11)),UPPER(L11)=\"X\"),1,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total",{"$f":"SUM(Z9:Z11)","v":0},0,0,0,0,0,0,0]
[]
["ACOMPANHAMENTO FÍSICO-FINANCEIRO"]
["PERÍODO 1:  0% a 12,5% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.125*$B$3+$B$1","v":"2006-09-15T15:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,null,null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
["PESSOAL + ENCARGOS",null,{"$f":"'PREVISÃO DE DESPESA'!I25","v":296318},{"$f":"IF(ISERR(C18/SUM($C$18:$C$34)*$Z$12),\"\",C18/SUM($C$18:$C$34)*$Z$12)","v":""},null,null,null,null,{"$f":"IF(ISERR(D18-E18),\"\",D18-E18)","v":""}]
["BOLSA ACADÊMICA",null,{"$f":"totalRubrica02","v":0},"",null,null,null,null,{"$f":"IF(ISERR(D19-E19),\"\",D19-E19)","v":""}]
["BOLSA ESTUDANTE",null,{"$f":"totalRubrica03","v":0},"",null,null,null,null,""]
["PESSOA FÍSICA",null,{"$f":"totalRubrica04","v":0},"",null,null,null,null,""]
["DIÁRIAS",null,{"$f":"totalRubrica05","v":0},"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,{"$f":"totalRubrica06","v":0},"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,{"$f":"totalRubrica07","v":0},"",null,null,null,null,""]
["PESSOA JURÍDICA",null,{"$f":"totalRubrica08","v":0},"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,{"$f":"totalRubrica09","v":0},"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,{"$f":"totalRubrica10","v":0},"",null,null,null,null,""]
["INSS EMPRESA",null,{"$f":"totalRubrica12","v":0},"",null,null,null,null,""]
["CPMF / TARIFAS",null,{"$f":"totalRubrica13","v":4889.2469999999994},"",null,null,null,null,""]
["FUNDEPES",null,{"$f":"totalRubrica14","v":29631.800000000003},"",null,null,null,null,""]
["UFAL",null,{"$f":"totalRubrica15","v":0},"",null,null,null,null,""]
["DEPARTAMENTO",null,{"$f":"totalRubrica16","v":0},"",null,null,null,null,""]
["FCPT",null,{"$f":"totalRubrica17","v":{"$error":"#REF!"}},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$f":"totalRubrica18","v":{"$error":"#REF!"}},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C18:C34)","v":{"$error":"#REF!"}},{"$f":"SUM(D18:D34)","v":0},{"$f":"SUM(E18:E34)","v":0},null,null,null,{"$f":"SUM(I18:L34)","v":0}]
[]
[]
[{"$f":"A14","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 2:  12,5% a 25% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.25*$B$3+$B$1","v":"2006-10-31T06:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,null,null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A18","v":"PESSOAL + ENCARGOS"},null,{"$f":"C18","v":296318},{"$f":"IF(ISERR(C42/SUM($C$42:$C$58)*$AA$12+I18),\"\",C42/SUM($C$42:$C$58)*$AA$12+I18)","v":""},null,null,null,null,{"$f":"IF(ISERR(D42-E42),\"\",D42-E42)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C43/SUM($C$42:$C$58)*$AA$12+I19),\"\",C43/SUM($C$42:$C$58)*$AA$12+I19)","v":""},null,null,null,null,{"$f":"IF(ISERR(D43-E43),\"\",D43-E43)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C42:C58)","v":{"$error":"#REF!"}},{"$f":"SUM(D42:D58)","v":0},{"$f":"SUM(E42:H58)","v":0},null,null,null,{"$f":"SUM(I42:L58)","v":0}]
[]
[]
[{"$f":"A38","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 3:  25% a 37,5% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.375*$B$3+$B$1","v":"2006-12-15T21:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,null,null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A18","v":"PESSOAL + ENCARGOS"},null,{"$f":"C18","v":296318},{"$f":"IF(ISERR(C66/SUM($C$66:$C$82)*$AB$12+I42),\"\",C66/SUM($C$66:$C$82)*$AB$12+I42)","v":""},null,null,null,null,{"$f":"IF(ISERR(D66-E66),\"\",D66-E66)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C67/SUM($C$66:$C$82)*$AB$12+I43),\"\",C67/SUM($C$66:$C$82)*$AB$12+I43)","v":""},null,null,null,null,{"$f":"IF(ISERR(D67-E67),\"\",D67-E67)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C66:C82)","v":{"$error":"#REF!"}},{"$f":"SUM(D66:D82)","v":0},{"$f":"SUM(E66:H82)","v":0},null,null,null,{"$f":"SUM(I66:L82)","v":0}]
[]
[]
[{"$f":"A62","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 4:  37,5% a 50% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.5*$B$3+$B$1","v":"2007-01-30T12:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,null,null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A18","v":"PESSOAL + ENCARGOS"},null,{"$f":"C18","v":296318},{"$f":"IF(ISERR(C90/SUM($C$90:$C$106)*$AC$12+I66),\"\",C90/SUM($C$90:$C$106)*$AC$12+I66)","v":""},null,null,null,null,{"$f":"IF(ISERR(D90-E90),\"\",D90-E90)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C91/SUM($C$90:$C$106)*$AC$12+I67),\"\",C91/SUM($C$90:$C$106)*$AC$12+I67)","v":""},null,null,null,null,{"$f":"IF(ISERR(D91-E91),\"\",D91-E91)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C90:C106)","v":{"$error":"#REF!"}},{"$f":"SUM(D90:D106)","v":0},{"$f":"SUM(E90:H106)","v":0},null,null,null,{"$f":"SUM(I90:L106)","v":0}]
[]
[]
[{"$f":"A86","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 5:  50% a 62,5% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.625*$B$3+$B$1","v":"2007-03-17T03:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,null,null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A42","v":"PESSOAL + ENCARGOS"},null,{"$f":"C42","v":296318},{"$f":"IF(ISERR(C114/SUM($C$114:$C$130)*$AD$12+I90),\"\",C114/SUM($C$114:$C$130)*$AD$12+I90)","v":""},null,null,null,null,{"$f":"IF(ISERR(D114-E114),\"\",D114-E114)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C115/SUM($C$114:$C$130)*$AD$12+I91),\"\",C115/SUM($C$114:$C$130)*$AD$12+I91)","v":""},null,null,null,null,{"$f":"IF(ISERR(D115-E115),\"\",D115-E115)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C114:C130)","v":{"$error":"#REF!"}},{"$f":"SUM(D114:D130)","v":0},{"$f":"SUM(E114:H130)","v":0},null,null,null,{"$f":"SUM(I114:L130)","v":0}]
[]
[]
[{"$f":"A110","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 6:  62,5% a 75% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.75*$B$3+$B$1","v":"2007-05-01T18:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,null,null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A66","v":"PESSOAL + ENCARGOS"},null,{"$f":"C66","v":296318},{"$f":"IF(ISERR(C138/SUM($C$138:$C$154)*$AE$12+I114),\"\",C138/SUM($C$138:$C$154)*$AE$12+I114)","v":""},null,null,null,null,{"$f":"IF(ISERR(D138-E138),\"\",D138-E138)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C139/SUM($C$138:$C$154)*$AE$12+I115),\"\",C139/SUM($C$138:$C$154)*$AE$12+I115)","v":""},null,null,null,null,{"$f":"IF(ISERR(D139-E139),\"\",D139-E139)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C138:C154)","v":{"$error":"#REF!"}},{"$f":"SUM(D138:D154)","v":0},{"$f":"SUM(E138:H154)","v":0},null,null,null,{"$f":"SUM(I138:L154)","v":0}]
[]
[]
[{"$f":"A134","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 7:  75% a 87,5% do tempo de projeto"]
["DATA LIMITE:",{"$f":"0.875*$B$3+$B$1","v":"2007-06-16T09:00:00"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,null,null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A90","v":"PESSOAL + ENCARGOS"},null,{"$f":"C90","v":296318},{"$f":"IF(ISERR(C162/SUM($C$162:$C$178)*$AF$12+I138),\"\",C162/SUM($C$162:$C$178)*$AF$12+I138)","v":""},null,null,null,null,{"$f":"IF(ISERR(D162-E162),\"\",D162-E162)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C163/SUM($C$162:$C$178)*$AF$12+I139),\"\",C163/SUM($C$162:$C$178)*$AF$12+I139)","v":""},null,null,null,null,{"$f":"IF(ISERR(D163-E163),\"\",D163-E163)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C162:C178)","v":{"$error":"#REF!"}},{"$f":"SUM(D162:D178)","v":0},{"$f":"SUM(E162:H178)","v":0},null,null,null,{"$f":"SUM(I162:L178)","v":0}]
[]
[]
[{"$f":"A158","v":"ACOMPANHAMENTO FÍSICO-FINANCEIRO"}]
["PERÍODO 8:  87,5% a 100% do tempo de projeto"]
["DATA LIMITE:",{"$f":"1*$B$3+$B$1","v":"2007-08-01"}]
["NOME DA RUBRICA",null,"VALOR","VALOR ESTIMADO","VALOR EXECUTADO",null,null,null,"SALDO",null,null,null,"META / ATIVIDADE",null,"CONTATO C/ COORDENADOR"]
[{"$f":"A114","v":"PESSOAL + ENCARGOS"},null,{"$f":"C114","v":296318},{"$f":"IF(ISERR(C186/SUM($C$186:$C$202)*$AG$12+I162),\"\",C186/SUM($C$186:$C$202)*$AG$12+I162)","v":""},null,null,null,null,{"$f":"IF(ISERR(D186-E186),\"\",D186-E186)","v":""}]
["BOLSA ACADÊMICA",null,0,{"$f":"IF(ISERR(C187/SUM($C$186:$C$202)*$AG$12+I163),\"\",C187/SUM($C$186:$C$202)*$AG$12+I163)","v":""},null,null,null,null,{"$f":"IF(ISERR(D187-E187),\"\",D187-E187)","v":""}]
["BOLSA ESTUDANTE",null,0,"",null,null,null,null,""]
["PESSOA FÍSICA",null,0,"",null,null,null,null,""]
["DIÁRIAS",null,0,"",null,null,null,null,""]
["PASSAGEM E LOCOMOÇÃO",null,0,"",null,null,null,null,""]
["MATERIAL DE CONSUMO",null,0,"",null,null,null,null,""]
["PESSOA JURÍDICA",null,0,"",null,null,null,null,""]
["OBRAS E INSTALAÇÕES",null,0,"",null,null,null,null,""]
["EQUIPAMENTO E MATERIAL",null,0,"",null,null,null,null,""]
["INSS EMPRESA",null,0,"",null,null,null,null,""]
["CPMF / TARIFAS",null,4889.2469999999994,"",null,null,null,null,""]
["FUNDEPES",null,29631.800000000003,"",null,null,null,null,""]
["UFAL",null,0,"",null,null,null,null,""]
["DEPARTAMENTO",null,0,"",null,null,null,null,""]
["FCPT",null,{"$error":"#REF!"},"",null,null,null,null,""]
["RESERVA TÉCNICA",null,{"$error":"#REF!"},"",null,null,null,null,""]
["TOTAL",null,{"$f":"SUM(C186:C202)","v":{"$error":"#REF!"}},{"$f":"SUM(D186:D202)","v":0},{"$f":"SUM(E186:H202)","v":0},null,null,null,{"$f":"SUM(I186:L202)","v":0}]

{"sheet":"AUXILIAR","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["qwertyuiop","<<< Senha Verdadeira"]
["projetos2020","<<< Senha 1"]
["13dez78","<<< Senha 2"]
["*FUNDEPES*","<<< Senha 3"]
[1,"<<< Protegido?"]
[null,"1 - sim"]
[null,"0 - não"]
[0,"<<< Visualizar?"]
[null,"1 - sim"]
[null,"0 - não"]
[true,"<<< Abertura?"]
["30 de março de 2020","<<< Versão 5","Modificações nas rubricas DESPESAS COM PESSOAL e ENCARGOS SOCIAIS. Criação da rubrica OBRIGAÇÕES PATRONAIS. Todas as principais modificações ocorreram na planilha PREVISÃO DE DESPESA."]
["27 de maio de 2020","<<< Versão 4","Alteração dos rótulos num03 e num04 para _num03 e _num04; Redução do texto dos botões Ocultar/Exibir; Acrescentado nos SOMATÓRIOS os totais das rubricas Seguro Estário e Auxilio Estudante; Modicação das fórmulas IR"]
["27 de maio de 2020","<<< Versão 4"]
["2008-03-16","<<< Versão 3"]
["2006-03-07","<<< Versão 2"]
["2005-07-05","<<< Versão 1"]